REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug) VALUES 
('GB', 'United Kingdom', 'united-kingdom');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(311, 'gb', 'London', 1, 'london');

;

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740441, 'gb', 'Bedfordshire', 1, 'bedfordshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34605, 740441, 'gb', 'Biggleswade', 1, 'biggleswade'),
(34606, 740441, 'gb', 'Dunstable', 1, 'dunstable'),
(34607, 740441, 'gb', 'Eversholt', 1, 'eversholt'),
(34608, 740441, 'gb', 'Kempston', 1, 'kempston'),
(34609, 740441, 'gb', 'Luton', 1, 'luton'),
(34610, 740441, 'gb', 'Bedford', 1, 'bedford');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740448, 'gb', 'Berkshire', 1, 'berkshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34611, 740448, 'gb', 'Slough', 1, 'slough'),
(34612, 740448, 'gb', 'Maidenhead', 1, 'maidenhead'),
(34613, 740448, 'gb', 'Bracknell', 1, 'bracknell'),
(34614, 740448, 'gb', 'Newbury', 1, 'newbury'),
(34615, 740448, 'gb', 'Windsor', 1, 'windsor'),
(34616, 740448, 'gb', 'Reading', 1, 'reading');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740455, 'gb', 'Bristol', 1, 'bristol');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34617, 740455, 'gb', 'Bristol', 1, 'bristol');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740457, 'gb', 'Buckinghamshire', 1, 'buckinghamshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34618, 740457, 'gb', 'Aylesbury', 1, 'aylesbury'),
(34619, 740457, 'gb', 'Buckingham', 1, 'buckingham'),
(34620, 740457, 'gb', 'Chesham', 1, 'chesham'),
(34621, 740457, 'gb', 'Winslow', 1, 'winslow');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740462, 'gb', 'Cambridgeshire', 1, 'cambridgeshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34622, 740462, 'gb', 'Cambridge', 1, 'cambridge'),
(34623, 740462, 'gb', 'Huntingdon', 1, 'huntingdon'),
(34624, 740462, 'gb', 'Peterborough', 1, 'peterborough'),
(34625, 740462, 'gb', 'Soham', 1, 'soham');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740467, 'gb', 'Cheshire', 1, 'cheshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34626, 740467, 'gb', 'Alderley Edge', 1, 'alderley-edge'),
(34627, 740467, 'gb', 'Chester', 1, 'chester'),
(34628, 740467, 'gb', 'Middlewich', 1, 'middlewich'),
(34629, 740467, 'gb', 'Northwich', 1, 'northwich'),
(34630, 740467, 'gb', 'Warrington', 1, 'warrington');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740473, 'gb', 'Cornwall', 1, 'cornwall');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34631, 740473, 'gb', 'Bodmin', 1, 'bodmin'),
(34632, 740473, 'gb', 'Boscastle', 1, 'boscastle'),
(34633, 740473, 'gb', 'Bude Stratton', 1, 'bude-stratton'),
(34634, 740473, 'gb', 'Callington', 1, 'callington'),
(34635, 740473, 'gb', 'Camborne', 1, 'camborne'),
(34636, 740473, 'gb', 'Camelford', 1, 'camelford'),
(34637, 740473, 'gb', 'Coverack', 1, 'coverack'),
(34638, 740473, 'gb', 'Falmouth', 1, 'falmouth'),
(34639, 740473, 'gb', 'Feock', 1, 'feock'),
(34640, 740473, 'gb', 'Fowey', 1, 'fowey'),
(34641, 740473, 'gb', 'Grampound', 1, 'grampound'),
(34642, 740473, 'gb', 'Hayle', 1, 'hayle'),
(34643, 740473, 'gb', 'Helston', 1, 'helston'),
(34644, 740473, 'gb', 'Holywell', 1, 'holywell'),
(34645, 740473, 'gb', 'Illogan', 1, 'illogan'),
(34646, 740473, 'gb', 'Isles Of Scilly', 1, 'isles-of-scilly'),
(34647, 740473, 'gb', 'Lands End', 1, 'lands-end'),
(34648, 740473, 'gb', 'Lansallos', 1, 'lansallos'),
(34649, 740473, 'gb', 'Liskeard', 1, 'liskeard'),
(34650, 740473, 'gb', 'Lizard', 1, 'lizard'),
(34651, 740473, 'gb', 'Looe', 1, 'looe'),
(34652, 740473, 'gb', 'Lostwithiel', 1, 'lostwithiel'),
(34653, 740473, 'gb', 'Madron', 1, 'madron'),
(34654, 740473, 'gb', 'Marazion', 1, 'marazion'),
(34655, 740473, 'gb', 'Mawgan', 1, 'mawgan'),
(34656, 740473, 'gb', 'Mullion', 1, 'mullion'),
(34657, 740473, 'gb', 'Newquay', 1, 'newquay'),
(34658, 740473, 'gb', 'Padstow', 1, 'padstow'),
(34659, 740473, 'gb', 'Penryn', 1, 'penryn'),
(34660, 740473, 'gb', 'Penzance', 1, 'penzance'),
(34661, 740473, 'gb', 'Perranporth', 1, 'perranporth'),
(34662, 740473, 'gb', 'Polperro', 1, 'polperro'),
(34663, 740473, 'gb', 'Porthcurno', 1, 'porthcurno'),
(34664, 740473, 'gb', 'Porthleven', 1, 'porthleven'),
(34665, 740473, 'gb', 'Port Isaac', 1, 'port-isaac'),
(34666, 740473, 'gb', 'Portscatho', 1, 'portscatho'),
(34667, 740473, 'gb', 'Portwrinkle', 1, 'portwrinkle'),
(34668, 740473, 'gb', 'Redruth', 1, 'redruth'),
(34669, 740473, 'gb', 'Rock', 1, 'rock'),
(34670, 740473, 'gb', 'Saint Austell', 1, 'saint-austell'),
(34671, 740473, 'gb', 'Saint Clement', 1, 'saint-clement'),
(34672, 740473, 'gb', 'Saint Mawes', 1, 'saint-mawes'),
(34673, 740473, 'gb', 'Saint Sampsons', 1, 'saint-sampsons'),
(34674, 740473, 'gb', 'Sennen', 1, 'sennen'),
(34675, 740473, 'gb', 'St. Agnes', 1, 'st-agnes'),
(34676, 740473, 'gb', 'St. Ives', 1, 'st-ives'),
(34677, 740473, 'gb', 'St. Keyne', 1, 'st-keyne'),
(34678, 740473, 'gb', 'St Erth', 1, 'st-erth'),
(34679, 740473, 'gb', 'St Martin', 1, 'st-martin'),
(34680, 740473, 'gb', 'Tintagel', 1, 'tintagel'),
(34681, 740473, 'gb', 'Torpoint', 1, 'torpoint'),
(34682, 740473, 'gb', 'Truro', 1, 'truro'),
(34683, 740473, 'gb', 'Uny Lelant', 1, 'uny-lelant'),
(34684, 740473, 'gb', 'Wadebridge', 1, 'wadebridge'),
(34685, 740473, 'gb', 'Zennor', 1, 'zennor');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740529, 'gb', 'Cumbria', 1, 'cumbria');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34686, 740529, 'gb', 'Alston', 1, 'alston'),
(34687, 740529, 'gb', 'Ambleside', 1, 'ambleside'),
(34688, 740529, 'gb', 'Appleby', 1, 'appleby'),
(34689, 740529, 'gb', 'Barrow in Furness', 1, 'barrow-in-furness'),
(34690, 740529, 'gb', 'Bassenthwaite', 1, 'bassenthwaite'),
(34691, 740529, 'gb', 'Birdoswald', 1, 'birdoswald'),
(34692, 740529, 'gb', 'Bowness on Windermere', 1, 'bowness-on-windermere'),
(34693, 740529, 'gb', 'Brampton', 1, 'brampton'),
(34694, 740529, 'gb', 'Bridgend', 1, 'bridgend'),
(34695, 740529, 'gb', 'Broughton in Furness', 1, 'broughton-in-furness'),
(34696, 740529, 'gb', 'Calder Bridge', 1, 'calder-bridge'),
(34697, 740529, 'gb', 'Carlisle', 1, 'carlisle'),
(34698, 740529, 'gb', 'Cartmel', 1, 'cartmel'),
(34699, 740529, 'gb', 'Cleator', 1, 'cleator'),
(34700, 740529, 'gb', 'Cleator Moor', 1, 'cleator-moor'),
(34701, 740529, 'gb', 'Cockermouth', 1, 'cockermouth'),
(34702, 740529, 'gb', 'Coniston', 1, 'coniston'),
(34703, 740529, 'gb', 'Crooklands', 1, 'crooklands'),
(34704, 740529, 'gb', 'Crosby On Eden', 1, 'crosby-on-eden'),
(34705, 740529, 'gb', 'Cumbria', 1, 'cumbria'),
(34706, 740529, 'gb', 'Egremont', 1, 'egremont'),
(34707, 740529, 'gb', 'Eskdale Green', 1, 'eskdale-green'),
(34708, 740529, 'gb', 'Far Sawrey', 1, 'far-sawrey'),
(34709, 740529, 'gb', 'Frizington', 1, 'frizington'),
(34710, 740529, 'gb', 'Glenridding', 1, 'glenridding'),
(34711, 740529, 'gb', 'Gosforth', 1, 'gosforth'),
(34712, 740529, 'gb', 'Grange Over Sands', 1, 'grange-over-sands'),
(34713, 740529, 'gb', 'Grasmere', 1, 'grasmere'),
(34714, 740529, 'gb', 'Grizedale', 1, 'grizedale'),
(34715, 740529, 'gb', 'Haverthwaite', 1, 'haverthwaite'),
(34716, 740529, 'gb', 'Hawkshead', 1, 'hawkshead'),
(34717, 740529, 'gb', 'Heversham', 1, 'heversham'),
(34718, 740529, 'gb', 'Kendal', 1, 'kendal'),
(34719, 740529, 'gb', 'Keswick', 1, 'keswick'),
(34720, 740529, 'gb', 'Kirkby-in-Furness', 1, 'kirkby-in-furness'),
(34721, 740529, 'gb', 'Kirkby Londsdale', 1, 'kirkby-londsdale'),
(34722, 740529, 'gb', 'Kirkby Stephen', 1, 'kirkby-stephen'),
(34723, 740529, 'gb', 'Kirkby Thore', 1, 'kirkby-thore'),
(34724, 740529, 'gb', 'Lakeside', 1, 'lakeside'),
(34725, 740529, 'gb', 'Langdale', 1, 'langdale'),
(34726, 740529, 'gb', 'Little Langdale', 1, 'little-langdale'),
(34727, 740529, 'gb', 'Maryport', 1, 'maryport'),
(34728, 740529, 'gb', 'Near Sawrey', 1, 'near-sawrey'),
(34729, 740529, 'gb', 'Newby Bridge', 1, 'newby-bridge'),
(34730, 740529, 'gb', 'Oxenholme', 1, 'oxenholme'),
(34731, 740529, 'gb', 'Penrith', 1, 'penrith'),
(34732, 740529, 'gb', 'Pooley Bridge', 1, 'pooley-bridge'),
(34733, 740529, 'gb', 'Portinscale', 1, 'portinscale'),
(34734, 740529, 'gb', 'Ravenglass', 1, 'ravenglass'),
(34735, 740529, 'gb', 'Ravenstonedale', 1, 'ravenstonedale'),
(34736, 740529, 'gb', 'Rydal', 1, 'rydal'),
(34737, 740529, 'gb', 'Sandwick', 1, 'sandwick'),
(34738, 740529, 'gb', 'Seascale', 1, 'seascale'),
(34739, 740529, 'gb', 'Sedbergh', 1, 'sedbergh'),
(34740, 740529, 'gb', 'Sedgwick', 1, 'sedgwick'),
(34741, 740529, 'gb', 'Sellafield', 1, 'sellafield'),
(34742, 740529, 'gb', 'Shap', 1, 'shap'),
(34743, 740529, 'gb', 'Staveley', 1, 'staveley'),
(34744, 740529, 'gb', 'Tebay', 1, 'tebay'),
(34745, 740529, 'gb', 'Temple Sowerby', 1, 'temple-sowerby'),
(34746, 740529, 'gb', 'Torver', 1, 'torver'),
(34747, 740529, 'gb', 'Troutbeck', 1, 'troutbeck'),
(34748, 740529, 'gb', 'Ullswater', 1, 'ullswater'),
(34749, 740529, 'gb', 'Ulverston', 1, 'ulverston'),
(34750, 740529, 'gb', 'Waterhead', 1, 'waterhead'),
(34751, 740529, 'gb', 'Watermillock', 1, 'watermillock'),
(34752, 740529, 'gb', 'Wetheral', 1, 'wetheral'),
(34753, 740529, 'gb', 'Whitehaven', 1, 'whitehaven'),
(34754, 740529, 'gb', 'Wigton', 1, 'wigton'),
(34755, 740529, 'gb', 'Windermere', 1, 'windermere'),
(34756, 740529, 'gb', 'Winscales', 1, 'winscales'),
(34757, 740529, 'gb', 'Workington', 1, 'workington');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740602, 'gb', 'Derbyshire', 1, 'derbyshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34758, 740602, 'gb', 'Alfreton', 1, 'alfreton'),
(34759, 740602, 'gb', 'Ashbourne', 1, 'ashbourne'),
(34760, 740602, 'gb', 'Ashford in the Water', 1, 'ashford-in-the-water'),
(34761, 740602, 'gb', 'Bakewell', 1, 'bakewell'),
(34762, 740602, 'gb', 'Baslow', 1, 'baslow'),
(34763, 740602, 'gb', 'Belper', 1, 'belper'),
(34764, 740602, 'gb', 'Burnaston', 1, 'burnaston'),
(34765, 740602, 'gb', 'Buxton', 1, 'buxton'),
(34766, 740602, 'gb', 'Castle Donington', 1, 'castle-donington'),
(34767, 740602, 'gb', 'Castlefields', 1, 'castlefields'),
(34768, 740602, 'gb', 'Castleton', 1, 'castleton'),
(34769, 740602, 'gb', 'Chapel en le Frith', 1, 'chapel-en-le-frith'),
(34770, 740602, 'gb', 'Chesterfield', 1, 'chesterfield'),
(34771, 740602, 'gb', 'Clowne', 1, 'clowne'),
(34772, 740602, 'gb', 'Denby', 1, 'denby'),
(34773, 740602, 'gb', 'Derby', 1, 'derby'),
(34774, 740602, 'gb', 'Doe Lea', 1, 'doe-lea'),
(34775, 740602, 'gb', 'Dovedale', 1, 'dovedale'),
(34776, 740602, 'gb', 'Etwall', 1, 'etwall'),
(34777, 740602, 'gb', 'Eyam', 1, 'eyam'),
(34778, 740602, 'gb', 'Glossop', 1, 'glossop'),
(34779, 740602, 'gb', 'Hathersage', 1, 'hathersage'),
(34780, 740602, 'gb', 'Hope', 1, 'hope'),
(34781, 740602, 'gb', 'Ilkestone', 1, 'ilkestone'),
(34782, 740602, 'gb', 'Long Eaton', 1, 'long-eaton'),
(34783, 740602, 'gb', 'Matlock', 1, 'matlock'),
(34784, 740602, 'gb', 'Matlock Bath', 1, 'matlock-bath'),
(34785, 740602, 'gb', 'Milford', 1, 'milford'),
(34786, 740602, 'gb', 'Morley', 1, 'morley'),
(34787, 740602, 'gb', 'Newbold', 1, 'newbold'),
(34788, 740602, 'gb', 'New Mills', 1, 'new-mills'),
(34789, 740602, 'gb', 'Renishaw', 1, 'renishaw'),
(34790, 740602, 'gb', 'Rowsley', 1, 'rowsley'),
(34791, 740602, 'gb', 'Sandiacre', 1, 'sandiacre'),
(34792, 740602, 'gb', 'Somercotes', 1, 'somercotes'),
(34793, 740602, 'gb', 'South Normanton', 1, 'south-normanton'),
(34794, 740602, 'gb', 'Stanley', 1, 'stanley'),
(34795, 740602, 'gb', 'Staveley', 1, 'staveley'),
(34796, 740602, 'gb', 'Sudbury', 1, 'sudbury'),
(34797, 740602, 'gb', 'Swadlincote', 1, 'swadlincote'),
(34798, 740602, 'gb', 'Thorpe', 1, 'thorpe'),
(34799, 740602, 'gb', 'Whaley Bridge', 1, 'whaley-bridge'),
(34800, 740602, 'gb', 'Whatstandwell', 1, 'whatstandwell'),
(34801, 740602, 'gb', 'Wirksworth', 1, 'wirksworth');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740647, 'gb', 'Devon', 1, 'devon');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34802, 740647, 'gb', 'Ashburton', 1, 'ashburton'),
(34803, 740647, 'gb', 'Axminster', 1, 'axminster'),
(34804, 740647, 'gb', 'Barnstaple', 1, 'barnstaple'),
(34805, 740647, 'gb', 'Bideford', 1, 'bideford'),
(34806, 740647, 'gb', 'Bigbury On Sea', 1, 'bigbury-on-sea'),
(34807, 740647, 'gb', 'Bolham', 1, 'bolham'),
(34808, 740647, 'gb', 'Boscombe', 1, 'boscombe'),
(34809, 740647, 'gb', 'Bovey Tracey', 1, 'bovey-tracey'),
(34810, 740647, 'gb', 'Branscombe', 1, 'branscombe'),
(34811, 740647, 'gb', 'Braunton', 1, 'braunton'),
(34812, 740647, 'gb', 'Brixham', 1, 'brixham'),
(34813, 740647, 'gb', 'Buckfastleigh', 1, 'buckfastleigh'),
(34814, 740647, 'gb', 'Budleigh Salterton', 1, 'budleigh-salterton'),
(34815, 740647, 'gb', 'Burrington', 1, 'burrington'),
(34816, 740647, 'gb', 'Chagford', 1, 'chagford'),
(34817, 740647, 'gb', 'Chardstock', 1, 'chardstock'),
(34818, 740647, 'gb', 'Churston Ferrers', 1, 'churston-ferrers'),
(34819, 740647, 'gb', 'Clawton', 1, 'clawton'),
(34820, 740647, 'gb', 'Clovelly', 1, 'clovelly'),
(34821, 740647, 'gb', 'Colyton', 1, 'colyton'),
(34822, 740647, 'gb', 'Compton', 1, 'compton'),
(34823, 740647, 'gb', 'Crediton', 1, 'crediton'),
(34824, 740647, 'gb', 'Cullompton', 1, 'cullompton'),
(34825, 740647, 'gb', 'Dartmoor National Park', 1, 'dartmoor-national-park'),
(34826, 740647, 'gb', 'Dartmouth', 1, 'dartmouth'),
(34827, 740647, 'gb', 'Dawlish', 1, 'dawlish'),
(34828, 740647, 'gb', 'Dittisham', 1, 'dittisham'),
(34829, 740647, 'gb', 'Down Thomas', 1, 'down-thomas'),
(34830, 740647, 'gb', 'Drewsteignton', 1, 'drewsteignton'),
(34831, 740647, 'gb', 'Ebford', 1, 'ebford'),
(34832, 740647, 'gb', 'Ermington', 1, 'ermington'),
(34833, 740647, 'gb', 'Exeter', 1, 'exeter'),
(34834, 740647, 'gb', 'Exmouth', 1, 'exmouth'),
(34835, 740647, 'gb', 'Farringdon', 1, 'farringdon'),
(34836, 740647, 'gb', 'Great Torrington', 1, 'great-torrington'),
(34837, 740647, 'gb', 'Hartland', 1, 'hartland'),
(34838, 740647, 'gb', 'Holsworthy', 1, 'holsworthy'),
(34839, 740647, 'gb', 'Honiton', 1, 'honiton'),
(34840, 740647, 'gb', 'Horrabridge', 1, 'horrabridge'),
(34841, 740647, 'gb', 'Huntsham', 1, 'huntsham'),
(34842, 740647, 'gb', 'Ilfracombe', 1, 'ilfracombe'),
(34843, 740647, 'gb', 'Instow', 1, 'instow'),
(34844, 740647, 'gb', 'Ivybridge', 1, 'ivybridge'),
(34845, 740647, 'gb', 'Kilmington', 1, 'kilmington'),
(34846, 740647, 'gb', 'Kingsbridge', 1, 'kingsbridge'),
(34847, 740647, 'gb', 'Kingswear', 1, 'kingswear'),
(34848, 740647, 'gb', 'Launceston', 1, 'launceston'),
(34849, 740647, 'gb', 'Lewdown', 1, 'lewdown'),
(34850, 740647, 'gb', 'Lewtrenchard', 1, 'lewtrenchard'),
(34851, 740647, 'gb', 'Lifton', 1, 'lifton'),
(34852, 740647, 'gb', 'Lynmouth', 1, 'lynmouth'),
(34853, 740647, 'gb', 'Lynton', 1, 'lynton'),
(34854, 740647, 'gb', 'Marwood', 1, 'marwood'),
(34855, 740647, 'gb', 'Milford', 1, 'milford'),
(34856, 740647, 'gb', 'Modbury', 1, 'modbury'),
(34857, 740647, 'gb', 'Moretonhampstead', 1, 'moretonhampstead'),
(34858, 740647, 'gb', 'Newton Abbot', 1, 'newton-abbot'),
(34859, 740647, 'gb', 'Newton Popplefor', 1, 'newton-popplefor'),
(34860, 740647, 'gb', 'North Tawton', 1, 'north-tawton'),
(34861, 740647, 'gb', 'Okehampton', 1, 'okehampton'),
(34862, 740647, 'gb', 'Ottery St Mary', 1, 'ottery-st-mary'),
(34863, 740647, 'gb', 'Paignton', 1, 'paignton'),
(34864, 740647, 'gb', 'Plymouth', 1, 'plymouth'),
(34865, 740647, 'gb', 'Princes Risborough', 1, 'princes-risborough'),
(34866, 740647, 'gb', 'Princetown', 1, 'princetown'),
(34867, 740647, 'gb', 'Salcombe', 1, 'salcombe'),
(34868, 740647, 'gb', 'Saltash', 1, 'saltash'),
(34869, 740647, 'gb', 'Sidmouth', 1, 'sidmouth'),
(34870, 740647, 'gb', 'Silvertown', 1, 'silvertown'),
(34871, 740647, 'gb', 'Sourton', 1, 'sourton'),
(34872, 740647, 'gb', 'South Molton', 1, 'south-molton'),
(34873, 740647, 'gb', 'Street', 1, 'street'),
(34874, 740647, 'gb', 'Tavistock', 1, 'tavistock'),
(34875, 740647, 'gb', 'Teignmouth', 1, 'teignmouth'),
(34876, 740647, 'gb', 'Thurlestone', 1, 'thurlestone'),
(34877, 740647, 'gb', 'Tiverton', 1, 'tiverton'),
(34878, 740647, 'gb', 'Topsham', 1, 'topsham'),
(34879, 740647, 'gb', 'Torbay', 1, 'torbay'),
(34880, 740647, 'gb', 'Torquay', 1, 'torquay'),
(34881, 740647, 'gb', 'Totnes', 1, 'totnes'),
(34882, 740647, 'gb', 'Two Bridges', 1, 'two-bridges'),
(34883, 740647, 'gb', 'Umberleigh', 1, 'umberleigh'),
(34884, 740647, 'gb', 'Widecombe in the Moor', 1, 'widecombe-in-the-moor'),
(34885, 740647, 'gb', 'Witheridge', 1, 'witheridge'),
(34886, 740647, 'gb', 'Woodford', 1, 'woodford'),
(34887, 740647, 'gb', 'Woolacombe', 1, 'woolacombe'),
(34888, 740647, 'gb', 'Yealmpton', 1, 'yealmpton'),
(34889, 740647, 'gb', 'Yelverton', 1, 'yelverton');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740736, 'gb', 'Dorset', 1, 'dorset');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34890, 740736, 'gb', 'Beaminster', 1, 'beaminster'),
(34891, 740736, 'gb', 'Blandford Forum', 1, 'blandford-forum'),
(34892, 740736, 'gb', 'Bournemouth', 1, 'bournemouth'),
(34893, 740736, 'gb', 'Bridport', 1, 'bridport'),
(34894, 740736, 'gb', 'Buckland Newton', 1, 'buckland-newton'),
(34895, 740736, 'gb', 'Castletown', 1, 'castletown'),
(34896, 740736, 'gb', 'Cerne Abbas', 1, 'cerne-abbas'),
(34897, 740736, 'gb', 'Charmouth', 1, 'charmouth'),
(34898, 740736, 'gb', 'Chedington', 1, 'chedington'),
(34899, 740736, 'gb', 'Christchurch', 1, 'christchurch'),
(34900, 740736, 'gb', 'Corfe Castle', 1, 'corfe-castle'),
(34901, 740736, 'gb', 'Cranborne', 1, 'cranborne'),
(34902, 740736, 'gb', 'Dorchester', 1, 'dorchester'),
(34903, 740736, 'gb', 'Evershot', 1, 'evershot'),
(34904, 740736, 'gb', 'Ferndown', 1, 'ferndown'),
(34905, 740736, 'gb', 'Gillingham', 1, 'gillingham'),
(34906, 740736, 'gb', 'Highcliffe', 1, 'highcliffe'),
(34907, 740736, 'gb', 'Higher Bockhampton', 1, 'higher-bockhampton'),
(34908, 740736, 'gb', 'Holywell', 1, 'holywell'),
(34909, 740736, 'gb', 'Lyme Regis', 1, 'lyme-regis'),
(34910, 740736, 'gb', 'Morden', 1, 'morden'),
(34911, 740736, 'gb', 'Moreton', 1, 'moreton'),
(34912, 740736, 'gb', 'Mudeford', 1, 'mudeford'),
(34913, 740736, 'gb', 'Poole', 1, 'poole'),
(34914, 740736, 'gb', 'Portland', 1, 'portland'),
(34915, 740736, 'gb', 'Puddletown', 1, 'puddletown'),
(34916, 740736, 'gb', 'Shaftesbury', 1, 'shaftesbury'),
(34917, 740736, 'gb', 'Sherborne', 1, 'sherborne'),
(34918, 740736, 'gb', 'Southwell', 1, 'southwell'),
(34919, 740736, 'gb', 'Sturminster Newton', 1, 'sturminster-newton'),
(34920, 740736, 'gb', 'Swanage', 1, 'swanage'),
(34921, 740736, 'gb', 'Wareham', 1, 'wareham'),
(34922, 740736, 'gb', 'West Bexington', 1, 'west-bexington'),
(34923, 740736, 'gb', 'Weymouth', 1, 'weymouth'),
(34924, 740736, 'gb', 'Wimborne Minster', 1, 'wimborne-minster'),
(34925, 740736, 'gb', 'Winfrith Newburg', 1, 'winfrith-newburg'),
(34926, 740736, 'gb', 'Wool', 1, 'wool');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740774, 'gb', 'Durham', 1, 'durham');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34927, 740774, 'gb', 'Barnard Castle', 1, 'barnard-castle'),
(34928, 740774, 'gb', 'Beamish', 1, 'beamish'),
(34929, 740774, 'gb', 'Billingham', 1, 'billingham'),
(34930, 740774, 'gb', 'Bishop Auckland', 1, 'bishop-auckland'),
(34931, 740774, 'gb', 'Bowes', 1, 'bowes'),
(34932, 740774, 'gb', 'Bowthorpe', 1, 'bowthorpe'),
(34933, 740774, 'gb', 'Brandon', 1, 'brandon'),
(34934, 740774, 'gb', 'Chester le Street', 1, 'chester-le-street'),
(34935, 740774, 'gb', 'Consett', 1, 'consett'),
(34936, 740774, 'gb', 'Crathorne Village', 1, 'crathorne-village'),
(34937, 740774, 'gb', 'Crook', 1, 'crook'),
(34938, 740774, 'gb', 'Darlington', 1, 'darlington'),
(34939, 740774, 'gb', 'Durham', 1, 'durham'),
(34940, 740774, 'gb', 'Easington Colliery', 1, 'easington-colliery'),
(34941, 740774, 'gb', 'Ferryhill', 1, 'ferryhill'),
(34942, 740774, 'gb', 'Greatham', 1, 'greatham'),
(34943, 740774, 'gb', 'Hartlepool', 1, 'hartlepool'),
(34944, 740774, 'gb', 'Mickleton', 1, 'mickleton'),
(34945, 740774, 'gb', 'New Elvet', 1, 'new-elvet'),
(34946, 740774, 'gb', 'Peterlee', 1, 'peterlee'),
(34947, 740774, 'gb', 'Piercebridge', 1, 'piercebridge'),
(34948, 740774, 'gb', 'Redcar', 1, 'redcar'),
(34949, 740774, 'gb', 'Redworth', 1, 'redworth'),
(34950, 740774, 'gb', 'Rushyford', 1, 'rushyford'),
(34951, 740774, 'gb', 'Seaham', 1, 'seaham'),
(34952, 740774, 'gb', 'Sedgefield', 1, 'sedgefield'),
(34953, 740774, 'gb', 'Shildon', 1, 'shildon'),
(34954, 740774, 'gb', 'Skelton', 1, 'skelton'),
(34955, 740774, 'gb', 'Spennymoor', 1, 'spennymoor'),
(34956, 740774, 'gb', 'Stanhope', 1, 'stanhope'),
(34957, 740774, 'gb', 'Stanley', 1, 'stanley'),
(34958, 740774, 'gb', 'Stockton On Tees', 1, 'stockton-on-tees'),
(34959, 740774, 'gb', 'Sund', 1, 'sund'),
(34960, 740774, 'gb', 'Thornaby On Tees', 1, 'thornaby-on-tees'),
(34961, 740774, 'gb', 'Tow Law', 1, 'tow-law'),
(34962, 740774, 'gb', 'Wolsingham', 1, 'wolsingham');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740811, 'gb', 'East Sussex', 1, 'east-sussex');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(34963, 740811, 'gb', 'Alfriston', 1, 'alfriston'),
(34964, 740811, 'gb', 'Battle', 1, 'battle'),
(34965, 740811, 'gb', 'Beckley', 1, 'beckley'),
(34966, 740811, 'gb', 'Bexhill', 1, 'bexhill'),
(34967, 740811, 'gb', 'Birling Gap', 1, 'birling-gap'),
(34968, 740811, 'gb', 'Brighton', 1, 'brighton'),
(34969, 740811, 'gb', 'Burwash', 1, 'burwash'),
(34970, 740811, 'gb', 'Crowborough', 1, 'crowborough'),
(34971, 740811, 'gb', 'Eastbourne', 1, 'eastbourne'),
(34972, 740811, 'gb', 'East Dean', 1, 'east-dean'),
(34973, 740811, 'gb', 'East Sussex', 1, 'east-sussex'),
(34974, 740811, 'gb', 'Etchingham', 1, 'etchingham'),
(34975, 740811, 'gb', 'Forest Row', 1, 'forest-row'),
(34976, 740811, 'gb', 'Glyndebourne', 1, 'glyndebourne'),
(34977, 740811, 'gb', 'Hadlow Down', 1, 'hadlow-down'),
(34978, 740811, 'gb', 'Hailsham', 1, 'hailsham'),
(34979, 740811, 'gb', 'Halland', 1, 'halland'),
(34980, 740811, 'gb', 'Hartfield', 1, 'hartfield'),
(34981, 740811, 'gb', 'Hastings', 1, 'hastings'),
(34982, 740811, 'gb', 'Heathfield', 1, 'heathfield'),
(34983, 740811, 'gb', 'Herstmonceux', 1, 'herstmonceux'),
(34984, 740811, 'gb', 'Hove', 1, 'hove'),
(34985, 740811, 'gb', 'Hurst Green', 1, 'hurst-green'),
(34986, 740811, 'gb', 'Lewes', 1, 'lewes'),
(34987, 740811, 'gb', 'Newhaven', 1, 'newhaven'),
(34988, 740811, 'gb', 'Newick', 1, 'newick'),
(34989, 740811, 'gb', 'Northiam', 1, 'northiam'),
(34990, 740811, 'gb', 'Pevensey Bay', 1, 'pevensey-bay'),
(34991, 740811, 'gb', 'Polegate', 1, 'polegate'),
(34992, 740811, 'gb', 'Robertsbridge', 1, 'robertsbridge'),
(34993, 740811, 'gb', 'Rodmell', 1, 'rodmell'),
(34994, 740811, 'gb', 'Rottingdean', 1, 'rottingdean'),
(34995, 740811, 'gb', 'Rushlake Green', 1, 'rushlake-green'),
(34996, 740811, 'gb', 'Rye', 1, 'rye'),
(34997, 740811, 'gb', 'Seaford', 1, 'seaford'),
(34998, 740811, 'gb', 'Sedlescombe', 1, 'sedlescombe'),
(34999, 740811, 'gb', 'St. Leonards', 1, 'st-leonards'),
(35000, 740811, 'gb', 'Ticehurst', 1, 'ticehurst'),
(35001, 740811, 'gb', 'Uckfield', 1, 'uckfield'),
(35002, 740811, 'gb', 'Wadhurst', 1, 'wadhurst'),
(35003, 740811, 'gb', 'Waldron', 1, 'waldron'),
(35004, 740811, 'gb', 'West Dean', 1, 'west-dean'),
(35005, 740811, 'gb', 'Winchelsea', 1, 'winchelsea');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740855, 'gb', 'East Yorkshire', 1, 'east-yorkshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35006, 740855, 'gb', 'Bentley', 1, 'bentley'),
(35007, 740855, 'gb', 'Beverley', 1, 'beverley'),
(35008, 740855, 'gb', 'Bridlington', 1, 'bridlington'),
(35009, 740855, 'gb', 'Brough', 1, 'brough'),
(35010, 740855, 'gb', 'Brus Laguna', 1, 'brus-laguna'),
(35011, 740855, 'gb', 'Coniston', 1, 'coniston'),
(35012, 740855, 'gb', 'Cottingham', 1, 'cottingham'),
(35013, 740855, 'gb', 'Flamborough Head', 1, 'flamborough-head'),
(35014, 740855, 'gb', 'Goole', 1, 'goole'),
(35015, 740855, 'gb', 'Grimsby', 1, 'grimsby'),
(35016, 740855, 'gb', 'Hedon', 1, 'hedon'),
(35017, 740855, 'gb', 'Hessle', 1, 'hessle'),
(35018, 740855, 'gb', 'Hornsea', 1, 'hornsea'),
(35019, 740855, 'gb', 'Howden', 1, 'howden'),
(35020, 740855, 'gb', 'Hull', 1, 'hull'),
(35021, 740855, 'gb', 'Kingston Upon Hull', 1, 'kingston-upon-hull'),
(35022, 740855, 'gb', 'North Ferriby', 1, 'north-ferriby'),
(35023, 740855, 'gb', 'Willerby', 1, 'willerby');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740874, 'gb', 'Essex', 1, 'essex');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35024, 740874, 'gb', 'Alresford', 1, 'alresford'),
(35025, 740874, 'gb', 'Audley End', 1, 'audley-end'),
(35026, 740874, 'gb', 'Basildon', 1, 'basildon'),
(35027, 740874, 'gb', 'Benfleet', 1, 'benfleet'),
(35028, 740874, 'gb', 'Bishop\'s Stortford', 1, 'bishops-stortford'),
(35029, 740874, 'gb', 'Bobbingworth', 1, 'bobbingworth'),
(35030, 740874, 'gb', 'Braintree', 1, 'braintree'),
(35031, 740874, 'gb', 'Brentwood', 1, 'brentwood'),
(35032, 740874, 'gb', 'Broxted', 1, 'broxted'),
(35033, 740874, 'gb', 'Buckhurst Hill', 1, 'buckhurst-hill'),
(35034, 740874, 'gb', 'Canvey Island', 1, 'canvey-island'),
(35035, 740874, 'gb', 'Chelmsford', 1, 'chelmsford'),
(35036, 740874, 'gb', 'Chigwell', 1, 'chigwell'),
(35037, 740874, 'gb', 'Chigwell Row', 1, 'chigwell-row'),
(35038, 740874, 'gb', 'Chingford', 1, 'chingford'),
(35039, 740874, 'gb', 'Chipping Ongar', 1, 'chipping-ongar'),
(35040, 740874, 'gb', 'Clacton On Sea', 1, 'clacton-on-sea'),
(35041, 740874, 'gb', 'Coggeshall', 1, 'coggeshall'),
(35042, 740874, 'gb', 'Colchester', 1, 'colchester'),
(35043, 740874, 'gb', 'Dedham', 1, 'dedham'),
(35044, 740874, 'gb', 'Dovercourt', 1, 'dovercourt'),
(35045, 740874, 'gb', 'East Horndon', 1, 'east-horndon'),
(35046, 740874, 'gb', 'Elmstead Market', 1, 'elmstead-market'),
(35047, 740874, 'gb', 'Epping', 1, 'epping'),
(35048, 740874, 'gb', 'Frinton On Sea', 1, 'frinton-on-sea'),
(35049, 740874, 'gb', 'Galleywood', 1, 'galleywood'),
(35050, 740874, 'gb', 'Grays', 1, 'grays'),
(35051, 740874, 'gb', 'Great Dunmow', 1, 'great-dunmow'),
(35052, 740874, 'gb', 'Great Saling', 1, 'great-saling'),
(35053, 740874, 'gb', 'Harlow', 1, 'harlow'),
(35054, 740874, 'gb', 'Harwich', 1, 'harwich'),
(35055, 740874, 'gb', 'Holland On Sea', 1, 'holland-on-sea'),
(35056, 740874, 'gb', 'Ingatestone', 1, 'ingatestone'),
(35057, 740874, 'gb', 'Kelvedon', 1, 'kelvedon'),
(35058, 740874, 'gb', 'Kirby Cross', 1, 'kirby-cross'),
(35059, 740874, 'gb', 'Lexden', 1, 'lexden'),
(35060, 740874, 'gb', 'London Stansted Airport', 1, 'london-stansted-airport'),
(35061, 740874, 'gb', 'Loughton', 1, 'loughton'),
(35062, 740874, 'gb', 'Maldon', 1, 'maldon'),
(35063, 740874, 'gb', 'Manningtree', 1, 'manningtree'),
(35064, 740874, 'gb', 'Moreton', 1, 'moreton'),
(35065, 740874, 'gb', 'North Stifford', 1, 'north-stifford'),
(35066, 740874, 'gb', 'Old Harlow', 1, 'old-harlow'),
(35067, 740874, 'gb', 'Rayleigh', 1, 'rayleigh'),
(35068, 740874, 'gb', 'Rochford', 1, 'rochford'),
(35069, 740874, 'gb', 'Romford', 1, 'romford'),
(35070, 740874, 'gb', 'Saffron Walden', 1, 'saffron-walden'),
(35071, 740874, 'gb', 'Southend On Sea', 1, 'southend-on-sea'),
(35072, 740874, 'gb', 'South Woodham Ferrers', 1, 'south-woodham-ferrers'),
(35073, 740874, 'gb', 'St. Osyth', 1, 'st-osyth'),
(35074, 740874, 'gb', 'Stansted', 1, 'stansted'),
(35075, 740874, 'gb', 'Stapleford Tawney', 1, 'stapleford-tawney'),
(35076, 740874, 'gb', 'Stock', 1, 'stock'),
(35077, 740874, 'gb', 'Thaxted', 1, 'thaxted'),
(35078, 740874, 'gb', 'Waltham Abbey', 1, 'waltham-abbey'),
(35079, 740874, 'gb', 'Waltham Cross', 1, 'waltham-cross'),
(35080, 740874, 'gb', 'Westcliff on Sea', 1, 'westcliff-on-sea'),
(35081, 740874, 'gb', 'Wickford', 1, 'wickford'),
(35082, 740874, 'gb', 'Witham', 1, 'witham'),
(35083, 740874, 'gb', 'Woodford Bridge', 1, 'woodford-bridge'),
(35084, 740874, 'gb', 'Writtle', 1, 'writtle');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740936, 'gb', 'Gloucestershire', 1, 'gloucestershire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35085, 740936, 'gb', 'Amberley', 1, 'amberley'),
(35086, 740936, 'gb', 'Andoverford', 1, 'andoverford'),
(35087, 740936, 'gb', 'Berkeley', 1, 'berkeley'),
(35088, 740936, 'gb', 'Bibury', 1, 'bibury'),
(35089, 740936, 'gb', 'Bisley', 1, 'bisley'),
(35090, 740936, 'gb', 'Blockley', 1, 'blockley'),
(35091, 740936, 'gb', 'Bourton On Hill', 1, 'bourton-on-hill'),
(35092, 740936, 'gb', 'Bourton On Water', 1, 'bourton-on-water'),
(35093, 740936, 'gb', 'Box', 1, 'box'),
(35094, 740936, 'gb', 'Broadwey', 1, 'broadwey'),
(35095, 740936, 'gb', 'Buckland', 1, 'buckland'),
(35096, 740936, 'gb', 'Cheltenham', 1, 'cheltenham'),
(35097, 740936, 'gb', 'Chipping Campden', 1, 'chipping-campden'),
(35098, 740936, 'gb', 'Cirencester', 1, 'cirencester'),
(35099, 740936, 'gb', 'Coleford', 1, 'coleford'),
(35100, 740936, 'gb', 'Coln St Aldwyns', 1, 'coln-st-aldwyns'),
(35101, 740936, 'gb', 'Donnington', 1, 'donnington'),
(35102, 740936, 'gb', 'Driffield', 1, 'driffield'),
(35103, 740936, 'gb', 'Duntisbourneleer', 1, 'duntisbourneleer'),
(35104, 740936, 'gb', 'Dursley', 1, 'dursley'),
(35105, 740936, 'gb', 'Fairford', 1, 'fairford'),
(35106, 740936, 'gb', 'Gloucester', 1, 'gloucester'),
(35107, 740936, 'gb', 'Kemble', 1, 'kemble'),
(35108, 740936, 'gb', 'Lechlade', 1, 'lechlade'),
(35109, 740936, 'gb', 'Little Barrington', 1, 'little-barrington'),
(35110, 740936, 'gb', 'Lower Slaughter', 1, 'lower-slaughter'),
(35111, 740936, 'gb', 'Lydney', 1, 'lydney'),
(35112, 740936, 'gb', 'Mitcheldean', 1, 'mitcheldean'),
(35113, 740936, 'gb', 'Moreton in Marsh', 1, 'moreton-in-marsh'),
(35114, 740936, 'gb', 'Nailsworth', 1, 'nailsworth'),
(35115, 740936, 'gb', 'Naunton', 1, 'naunton'),
(35116, 740936, 'gb', 'Newent', 1, 'newent'),
(35117, 740936, 'gb', 'Northleach', 1, 'northleach'),
(35118, 740936, 'gb', 'Painswick', 1, 'painswick'),
(35119, 740936, 'gb', 'Prestbury', 1, 'prestbury'),
(35120, 740936, 'gb', 'Sandhurst', 1, 'sandhurst'),
(35121, 740936, 'gb', 'Sapperton', 1, 'sapperton'),
(35122, 740936, 'gb', 'Sedbury', 1, 'sedbury'),
(35123, 740936, 'gb', 'Shipton', 1, 'shipton'),
(35124, 740936, 'gb', 'Shurdington', 1, 'shurdington'),
(35125, 740936, 'gb', 'Snowshill', 1, 'snowshill'),
(35126, 740936, 'gb', 'Stanton', 1, 'stanton'),
(35127, 740936, 'gb', 'Stone', 1, 'stone'),
(35128, 740936, 'gb', 'Stonehouse', 1, 'stonehouse'),
(35129, 740936, 'gb', 'Stow On the Wold', 1, 'stow-on-the-wold'),
(35130, 740936, 'gb', 'Stroud', 1, 'stroud'),
(35131, 740936, 'gb', 'Teddington', 1, 'teddington'),
(35132, 740936, 'gb', 'Tetbury', 1, 'tetbury'),
(35133, 740936, 'gb', 'Tewkesbury', 1, 'tewkesbury'),
(35134, 740936, 'gb', 'Toddington', 1, 'toddington'),
(35135, 740936, 'gb', 'Tormarton', 1, 'tormarton'),
(35136, 740936, 'gb', 'Tortworth', 1, 'tortworth'),
(35137, 740936, 'gb', 'Uley', 1, 'uley'),
(35138, 740936, 'gb', 'Upper Slaughter', 1, 'upper-slaughter'),
(35139, 740936, 'gb', 'Westonbirt', 1, 'westonbirt'),
(35140, 740936, 'gb', 'Willersey', 1, 'willersey'),
(35141, 740936, 'gb', 'Winchcombe', 1, 'winchcombe'),
(35142, 740936, 'gb', 'Woodford', 1, 'woodford'),
(35143, 740936, 'gb', 'Wotton Under Edge', 1, 'wotton-under-edge');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(740996, 'gb', 'Great London', 1, 'great-london');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35144, 740996, 'gb', 'Abbey Wood', 1, 'abbey-wood'),
(35145, 740996, 'gb', 'Banstead', 1, 'banstead'),
(35146, 740996, 'gb', 'Barking Essex', 1, 'barking-essex'),
(35147, 740996, 'gb', 'Barkingside', 1, 'barkingside'),
(35148, 740996, 'gb', 'Barnet', 1, 'barnet'),
(35149, 740996, 'gb', 'Bayswater', 1, 'bayswater'),
(35150, 740996, 'gb', 'Beckenham', 1, 'beckenham'),
(35151, 740996, 'gb', 'Bickley', 1, 'bickley'),
(35152, 740996, 'gb', 'Biggin Hill', 1, 'biggin-hill'),
(35153, 740996, 'gb', 'Blackheath', 1, 'blackheath'),
(35154, 740996, 'gb', 'Brent Cross', 1, 'brent-cross'),
(35155, 740996, 'gb', 'Brentford', 1, 'brentford'),
(35156, 740996, 'gb', 'Bromley', 1, 'bromley'),
(35157, 740996, 'gb', 'Camden', 1, 'camden'),
(35158, 740996, 'gb', 'Carshalton', 1, 'carshalton'),
(35159, 740996, 'gb', 'Chalfont St Giles', 1, 'chalfont-st-giles'),
(35160, 740996, 'gb', 'Chertsey', 1, 'chertsey'),
(35161, 740996, 'gb', 'Cheshunt', 1, 'cheshunt'),
(35162, 740996, 'gb', 'Chessington', 1, 'chessington'),
(35163, 740996, 'gb', 'Colnbrook', 1, 'colnbrook'),
(35164, 740996, 'gb', 'Coulsdon', 1, 'coulsdon'),
(35165, 740996, 'gb', 'Cranford', 1, 'cranford'),
(35166, 740996, 'gb', 'Cricklewood', 1, 'cricklewood'),
(35167, 740996, 'gb', 'Croydon', 1, 'croydon'),
(35168, 740996, 'gb', 'Dagenham', 1, 'dagenham'),
(35169, 740996, 'gb', 'Ealing', 1, 'ealing'),
(35170, 740996, 'gb', 'Enfield', 1, 'enfield'),
(35171, 740996, 'gb', 'Epping Forest', 1, 'epping-forest'),
(35172, 740996, 'gb', 'Feltham', 1, 'feltham'),
(35173, 740996, 'gb', 'Finchley', 1, 'finchley'),
(35174, 740996, 'gb', 'Greenbottom Near Tru', 1, 'greenbottom-near-tru'),
(35175, 740996, 'gb', 'Greenford', 1, 'greenford'),
(35176, 740996, 'gb', 'Greenhithe', 1, 'greenhithe'),
(35177, 740996, 'gb', 'Greenwich', 1, 'greenwich'),
(35178, 740996, 'gb', 'Hampstead', 1, 'hampstead'),
(35179, 740996, 'gb', 'Harmondsworth', 1, 'harmondsworth'),
(35180, 740996, 'gb', 'Harrow', 1, 'harrow'),
(35181, 740996, 'gb', 'Hayes', 1, 'hayes'),
(35182, 740996, 'gb', 'Hendon', 1, 'hendon'),
(35183, 740996, 'gb', 'Hillingdon', 1, 'hillingdon'),
(35184, 740996, 'gb', 'Hornchurch', 1, 'hornchurch'),
(35185, 740996, 'gb', 'Hounslow', 1, 'hounslow'),
(35186, 740996, 'gb', 'Ilford', 1, 'ilford'),
(35187, 740996, 'gb', 'Isleworth', 1, 'isleworth'),
(35188, 740996, 'gb', 'Kenley', 1, 'kenley'),
(35189, 740996, 'gb', 'Kensington y Chelsea', 1, 'kensington-y-chelsea'),
(35190, 740996, 'gb', 'Kingston Upon Thames', 1, 'kingston-upon-thames'),
(35191, 740996, 'gb', 'Londres', 1, 'londres'),
(35192, 740996, 'gb', 'Mill Hill', 1, 'mill-hill'),
(35193, 740996, 'gb', 'Mitcham', 1, 'mitcham'),
(35194, 740996, 'gb', 'Morden', 1, 'morden'),
(35195, 740996, 'gb', 'New Malden', 1, 'new-malden'),
(35196, 740996, 'gb', 'Orpington', 1, 'orpington'),
(35197, 740996, 'gb', 'Pinner', 1, 'pinner'),
(35198, 740996, 'gb', 'Purley', 1, 'purley'),
(35199, 740996, 'gb', 'Putney', 1, 'putney'),
(35200, 740996, 'gb', 'Rainham', 1, 'rainham'),
(35201, 740996, 'gb', 'Richmond Upon Thames', 1, 'richmond-upon-thames'),
(35202, 740996, 'gb', 'Ruislip', 1, 'ruislip'),
(35203, 740996, 'gb', 'Southall', 1, 'southall'),
(35204, 740996, 'gb', 'St. Pauls Cray', 1, 'st-pauls-cray'),
(35205, 740996, 'gb', 'Stanmore', 1, 'stanmore'),
(35206, 740996, 'gb', 'St Mary Cray', 1, 'st-mary-cray'),
(35207, 740996, 'gb', 'Sudbury', 1, 'sudbury'),
(35208, 740996, 'gb', 'Sunbury', 1, 'sunbury'),
(35209, 740996, 'gb', 'Surrey', 1, 'surrey'),
(35210, 740996, 'gb', 'Sydenham', 1, 'sydenham'),
(35211, 740996, 'gb', 'Thurrockc', 1, 'thurrockc'),
(35212, 740996, 'gb', 'Tolworth', 1, 'tolworth'),
(35213, 740996, 'gb', 'Twickenham', 1, 'twickenham'),
(35214, 740996, 'gb', 'Uxbridge', 1, 'uxbridge'),
(35215, 740996, 'gb', 'Waltahmstow', 1, 'waltahmstow'),
(35216, 740996, 'gb', 'Wandsworth', 1, 'wandsworth'),
(35217, 740996, 'gb', 'Welling', 1, 'welling'),
(35218, 740996, 'gb', 'Wembley', 1, 'wembley'),
(35219, 740996, 'gb', 'West Drayton', 1, 'west-drayton'),
(35220, 740996, 'gb', 'Westminster', 1, 'westminster'),
(35221, 740996, 'gb', 'Wimbledon', 1, 'wimbledon'),
(35222, 740996, 'gb', 'Woodford', 1, 'woodford'),
(35223, 740996, 'gb', 'Woodford Green', 1, 'woodford-green'),
(35224, 740996, 'gb', 'Woolwich', 1, 'woolwich');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741078, 'gb', 'Great Manchester', 1, 'great-manchester');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35225, 741078, 'gb', 'Altrincham', 1, 'altrincham'),
(35226, 741078, 'gb', 'Ashton-Under-Lyne', 1, 'ashton-under-lyne'),
(35227, 741078, 'gb', 'Ashton in Makerfield', 1, 'ashton-in-makerfield'),
(35228, 741078, 'gb', 'Blackwood', 1, 'blackwood'),
(35229, 741078, 'gb', 'Boothstown', 1, 'boothstown'),
(35230, 741078, 'gb', 'Bowdon', 1, 'bowdon'),
(35231, 741078, 'gb', 'Brands Hatch', 1, 'brands-hatch'),
(35232, 741078, 'gb', 'Bury', 1, 'bury'),
(35233, 741078, 'gb', 'Cheadle', 1, 'cheadle'),
(35234, 741078, 'gb', 'Davyhulme', 1, 'davyhulme'),
(35235, 741078, 'gb', 'Denton', 1, 'denton'),
(35236, 741078, 'gb', 'Didsbury', 1, 'didsbury'),
(35237, 741078, 'gb', 'Halebarns', 1, 'halebarns'),
(35238, 741078, 'gb', 'Handforth', 1, 'handforth'),
(35239, 741078, 'gb', 'Hyde', 1, 'hyde'),
(35240, 741078, 'gb', 'Leigh', 1, 'leigh'),
(35241, 741078, 'gb', 'Manchester', 1, 'manchester'),
(35242, 741078, 'gb', 'Marple', 1, 'marple'),
(35243, 741078, 'gb', 'Oldham', 1, 'oldham'),
(35244, 741078, 'gb', 'Prestwich', 1, 'prestwich'),
(35245, 741078, 'gb', 'Ramsbottom', 1, 'ramsbottom'),
(35246, 741078, 'gb', 'Saddleworth', 1, 'saddleworth'),
(35247, 741078, 'gb', 'Sale', 1, 'sale'),
(35248, 741078, 'gb', 'Salford', 1, 'salford'),
(35249, 741078, 'gb', 'Stockport', 1, 'stockport'),
(35250, 741078, 'gb', 'Swinton', 1, 'swinton'),
(35251, 741078, 'gb', 'Whitefield', 1, 'whitefield'),
(35252, 741078, 'gb', 'Wigan', 1, 'wigan'),
(35253, 741078, 'gb', 'Wilmslow', 1, 'wilmslow'),
(35254, 741078, 'gb', 'Wythenshawe', 1, 'wythenshawe');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741109, 'gb', 'Hampshire', 1, 'hampshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35255, 741109, 'gb', 'Aldershot', 1, 'aldershot'),
(35256, 741109, 'gb', 'Alton', 1, 'alton'),
(35257, 741109, 'gb', 'Ampfield', 1, 'ampfield'),
(35258, 741109, 'gb', 'Andover', 1, 'andover'),
(35259, 741109, 'gb', 'Ashford Hill', 1, 'ashford-hill'),
(35260, 741109, 'gb', 'Basingstoke', 1, 'basingstoke'),
(35261, 741109, 'gb', 'Beaulieu', 1, 'beaulieu'),
(35262, 741109, 'gb', 'Bentley', 1, 'bentley'),
(35263, 741109, 'gb', 'Botley', 1, 'botley'),
(35264, 741109, 'gb', 'Bramdean', 1, 'bramdean'),
(35265, 741109, 'gb', 'Brockenhurst', 1, 'brockenhurst'),
(35266, 741109, 'gb', 'Broughton', 1, 'broughton'),
(35267, 741109, 'gb', 'Burley', 1, 'burley'),
(35268, 741109, 'gb', 'Chawton', 1, 'chawton'),
(35269, 741109, 'gb', 'Chineham', 1, 'chineham'),
(35270, 741109, 'gb', 'Compton', 1, 'compton'),
(35271, 741109, 'gb', 'Crawley', 1, 'crawley'),
(35272, 741109, 'gb', 'Droxford', 1, 'droxford'),
(35273, 741109, 'gb', 'Eastleigh', 1, 'eastleigh'),
(35274, 741109, 'gb', 'East Wellow', 1, 'east-wellow'),
(35275, 741109, 'gb', 'Eversley', 1, 'eversley'),
(35276, 741109, 'gb', 'Exbury', 1, 'exbury'),
(35277, 741109, 'gb', 'Fareham', 1, 'fareham'),
(35278, 741109, 'gb', 'Farnborough', 1, 'farnborough'),
(35279, 741109, 'gb', 'Fleet', 1, 'fleet'),
(35280, 741109, 'gb', 'Fordingbridge', 1, 'fordingbridge'),
(35281, 741109, 'gb', 'Four Marks', 1, 'four-marks'),
(35282, 741109, 'gb', 'Gosport', 1, 'gosport'),
(35283, 741109, 'gb', 'Grayshott', 1, 'grayshott'),
(35284, 741109, 'gb', 'Greatham', 1, 'greatham'),
(35285, 741109, 'gb', 'Hambledon', 1, 'hambledon'),
(35286, 741109, 'gb', 'Hartley Wintney', 1, 'hartley-wintney'),
(35287, 741109, 'gb', 'Havant', 1, 'havant'),
(35288, 741109, 'gb', 'Hayling Island', 1, 'hayling-island'),
(35289, 741109, 'gb', 'Headley', 1, 'headley'),
(35290, 741109, 'gb', 'Hedge End', 1, 'hedge-end'),
(35291, 741109, 'gb', 'Hook', 1, 'hook'),
(35292, 741109, 'gb', 'Horndean', 1, 'horndean'),
(35293, 741109, 'gb', 'Hurstbourme Tarrant', 1, 'hurstbourme-tarrant'),
(35294, 741109, 'gb', 'Hythe', 1, 'hythe'),
(35295, 741109, 'gb', 'Kings Worthy', 1, 'kings-worthy'),
(35296, 741109, 'gb', 'Lee On Solent', 1, 'lee-on-solent'),
(35297, 741109, 'gb', 'Liphook', 1, 'liphook'),
(35298, 741109, 'gb', 'Locks Heath', 1, 'locks-heath'),
(35299, 741109, 'gb', 'Lymington', 1, 'lymington'),
(35300, 741109, 'gb', 'Lyndhurst', 1, 'lyndhurst'),
(35301, 741109, 'gb', 'Milford On Sea', 1, 'milford-on-sea'),
(35302, 741109, 'gb', 'Minstead', 1, 'minstead'),
(35303, 741109, 'gb', 'Mottisfont', 1, 'mottisfont'),
(35304, 741109, 'gb', 'Nether Wallop', 1, 'nether-wallop'),
(35305, 741109, 'gb', 'New Forest', 1, 'new-forest'),
(35306, 741109, 'gb', 'New Milton', 1, 'new-milton'),
(35307, 741109, 'gb', 'North Waltham', 1, 'north-waltham'),
(35308, 741109, 'gb', 'Odiham', 1, 'odiham'),
(35309, 741109, 'gb', 'Otterboune', 1, 'otterboune'),
(35310, 741109, 'gb', 'Petersfield', 1, 'petersfield'),
(35311, 741109, 'gb', 'Portchester', 1, 'portchester'),
(35312, 741109, 'gb', 'Portsmouth', 1, 'portsmouth'),
(35313, 741109, 'gb', 'Ringwood', 1, 'ringwood'),
(35314, 741109, 'gb', 'Romsey', 1, 'romsey'),
(35315, 741109, 'gb', 'Rotherwick', 1, 'rotherwick'),
(35316, 741109, 'gb', 'Saint Leonards', 1, 'saint-leonards'),
(35317, 741109, 'gb', 'Southampton', 1, 'southampton'),
(35318, 741109, 'gb', 'Southsea', 1, 'southsea'),
(35319, 741109, 'gb', 'Southwick', 1, 'southwick'),
(35320, 741109, 'gb', 'Steventon', 1, 'steventon'),
(35321, 741109, 'gb', 'Stockbridge', 1, 'stockbridge'),
(35322, 741109, 'gb', 'Sutton Scotney', 1, 'sutton-scotney'),
(35323, 741109, 'gb', 'Tadley', 1, 'tadley'),
(35324, 741109, 'gb', 'Upton Grey', 1, 'upton-grey'),
(35325, 741109, 'gb', 'Waterlooville', 1, 'waterlooville'),
(35326, 741109, 'gb', 'West Meon', 1, 'west-meon'),
(35327, 741109, 'gb', 'Wheatley', 1, 'wheatley'),
(35328, 741109, 'gb', 'Wickham', 1, 'wickham'),
(35329, 741109, 'gb', 'Winchester', 1, 'winchester'),
(35330, 741109, 'gb', 'Yateley', 1, 'yateley');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741186, 'gb', 'Herefordshire', 1, 'herefordshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35331, 741186, 'gb', 'Bredwardine', 1, 'bredwardine'),
(35332, 741186, 'gb', 'Bromyard', 1, 'bromyard'),
(35333, 741186, 'gb', 'Donnington', 1, 'donnington'),
(35334, 741186, 'gb', 'Eardisley', 1, 'eardisley'),
(35335, 741186, 'gb', 'Fownhope', 1, 'fownhope'),
(35336, 741186, 'gb', 'Greater Malvern', 1, 'greater-malvern'),
(35337, 741186, 'gb', 'Hereford', 1, 'hereford'),
(35338, 741186, 'gb', 'Kington', 1, 'kington'),
(35339, 741186, 'gb', 'Ledbury', 1, 'ledbury'),
(35340, 741186, 'gb', 'Leominster', 1, 'leominster'),
(35341, 741186, 'gb', 'Marden', 1, 'marden'),
(35342, 741186, 'gb', 'Pembridge', 1, 'pembridge'),
(35343, 741186, 'gb', 'Ross On Wye', 1, 'ross-on-wye'),
(35344, 741186, 'gb', 'Whitney', 1, 'whitney'),
(35345, 741186, 'gb', 'Wilton', 1, 'wilton'),
(35346, 741186, 'gb', 'Winforton', 1, 'winforton');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741203, 'gb', 'Hertfordshire', 1, 'hertfordshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35347, 741203, 'gb', 'Ashwell', 1, 'ashwell'),
(35348, 741203, 'gb', 'Baldock', 1, 'baldock'),
(35349, 741203, 'gb', 'Benington', 1, 'benington'),
(35350, 741203, 'gb', 'Berkhamsted', 1, 'berkhamsted'),
(35351, 741203, 'gb', 'Bishops Stortford', 1, 'bishops-stortford'),
(35352, 741203, 'gb', 'Borehamwood', 1, 'borehamwood'),
(35353, 741203, 'gb', 'Broxbourne', 1, 'broxbourne'),
(35354, 741203, 'gb', 'Buntingford', 1, 'buntingford'),
(35355, 741203, 'gb', 'Bushey', 1, 'bushey'),
(35356, 741203, 'gb', 'Chandler\'s Cross', 1, 'chandlers-cross'),
(35357, 741203, 'gb', 'Cheshunt', 1, 'cheshunt'),
(35358, 741203, 'gb', 'Chipperfield', 1, 'chipperfield'),
(35359, 741203, 'gb', 'Chorleywood', 1, 'chorleywood'),
(35360, 741203, 'gb', 'Elstree', 1, 'elstree'),
(35361, 741203, 'gb', 'Essendon', 1, 'essendon'),
(35362, 741203, 'gb', 'Great Amwell', 1, 'great-amwell'),
(35363, 741203, 'gb', 'Hadley Wood', 1, 'hadley-wood'),
(35364, 741203, 'gb', 'Harpenden', 1, 'harpenden'),
(35365, 741203, 'gb', 'Hatfield', 1, 'hatfield'),
(35366, 741203, 'gb', 'Hemel Hempstead', 1, 'hemel-hempstead'),
(35367, 741203, 'gb', 'Hertford', 1, 'hertford'),
(35368, 741203, 'gb', 'Hertingfordbury', 1, 'hertingfordbury'),
(35369, 741203, 'gb', 'Herts', 1, 'herts'),
(35370, 741203, 'gb', 'Hitchin', 1, 'hitchin'),
(35371, 741203, 'gb', 'Knebworth', 1, 'knebworth'),
(35372, 741203, 'gb', 'Letchworth', 1, 'letchworth'),
(35373, 741203, 'gb', 'London Colney', 1, 'london-colney'),
(35374, 741203, 'gb', 'Markyate', 1, 'markyate'),
(35375, 741203, 'gb', 'Much Hadham', 1, 'much-hadham'),
(35376, 741203, 'gb', 'Potters Bar', 1, 'potters-bar'),
(35377, 741203, 'gb', 'Radlett', 1, 'radlett'),
(35378, 741203, 'gb', 'Rickmansworth', 1, 'rickmansworth'),
(35379, 741203, 'gb', 'Royston', 1, 'royston'),
(35380, 741203, 'gb', 'Saint Owens Cross', 1, 'saint-owens-cross'),
(35381, 741203, 'gb', 'Sawbridgeworth', 1, 'sawbridgeworth'),
(35382, 741203, 'gb', 'South Mimms', 1, 'south-mimms'),
(35383, 741203, 'gb', 'St. Albans', 1, 'st-albans'),
(35384, 741203, 'gb', 'Stanstead Abbots', 1, 'stanstead-abbots'),
(35385, 741203, 'gb', 'Stevenage', 1, 'stevenage'),
(35386, 741203, 'gb', 'Tring', 1, 'tring'),
(35387, 741203, 'gb', 'Ware', 1, 'ware'),
(35388, 741203, 'gb', 'Watford', 1, 'watford'),
(35389, 741203, 'gb', 'Welham Green', 1, 'welham-green'),
(35390, 741203, 'gb', 'Welwyn', 1, 'welwyn'),
(35391, 741203, 'gb', 'Welwyn Garden City', 1, 'welwyn-garden-city'),
(35392, 741203, 'gb', 'West Cheshunt', 1, 'west-cheshunt'),
(35393, 741203, 'gb', 'Wheathampstead', 1, 'wheathampstead'),
(35394, 741203, 'gb', 'Wigginton', 1, 'wigginton'),
(35395, 741203, 'gb', 'Wigmore', 1, 'wigmore'),
(35396, 741203, 'gb', 'Wormley', 1, 'wormley');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741254, 'gb', 'Isle de Wight', 1, 'isle-de-wight');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35397, 741254, 'gb', 'Alverstone', 1, 'alverstone'),
(35398, 741254, 'gb', 'Ardgay', 1, 'ardgay'),
(35399, 741254, 'gb', 'Bonchurch', 1, 'bonchurch'),
(35400, 741254, 'gb', 'Cowes', 1, 'cowes'),
(35401, 741254, 'gb', 'East Cowes', 1, 'east-cowes'),
(35402, 741254, 'gb', 'Freshwater Bay', 1, 'freshwater-bay'),
(35403, 741254, 'gb', 'Newport', 1, 'newport'),
(35404, 741254, 'gb', 'Northwood', 1, 'northwood'),
(35405, 741254, 'gb', 'Ryde', 1, 'ryde'),
(35406, 741254, 'gb', 'Saint Helens', 1, 'saint-helens'),
(35407, 741254, 'gb', 'Sandown', 1, 'sandown'),
(35408, 741254, 'gb', 'Seaview', 1, 'seaview'),
(35409, 741254, 'gb', 'Shanklin', 1, 'shanklin'),
(35410, 741254, 'gb', 'Ventnor', 1, 'ventnor'),
(35411, 741254, 'gb', 'Yarmouth', 1, 'yarmouth');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741270, 'gb', 'Kent', 1, 'kent');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35412, 741270, 'gb', 'Ashford', 1, 'ashford'),
(35413, 741270, 'gb', 'Aylesford', 1, 'aylesford'),
(35414, 741270, 'gb', 'Bexley', 1, 'bexley'),
(35415, 741270, 'gb', 'Bexleyheath', 1, 'bexleyheath'),
(35416, 741270, 'gb', 'Biddenden', 1, 'biddenden'),
(35417, 741270, 'gb', 'Birchington', 1, 'birchington'),
(35418, 741270, 'gb', 'Borough Green', 1, 'borough-green'),
(35419, 741270, 'gb', 'Brasted', 1, 'brasted'),
(35420, 741270, 'gb', 'Brenchley', 1, 'brenchley'),
(35421, 741270, 'gb', 'Broadstairs', 1, 'broadstairs'),
(35422, 741270, 'gb', 'Canterbury', 1, 'canterbury'),
(35423, 741270, 'gb', 'Chatham', 1, 'chatham'),
(35424, 741270, 'gb', 'Chiddingstone', 1, 'chiddingstone'),
(35425, 741270, 'gb', 'Chilham', 1, 'chilham'),
(35426, 741270, 'gb', 'Cranbrook', 1, 'cranbrook'),
(35427, 741270, 'gb', 'Dartford', 1, 'dartford'),
(35428, 741270, 'gb', 'Deal', 1, 'deal'),
(35429, 741270, 'gb', 'Dover', 1, 'dover'),
(35430, 741270, 'gb', 'Eastchurch', 1, 'eastchurch'),
(35431, 741270, 'gb', 'East Malling', 1, 'east-malling'),
(35432, 741270, 'gb', 'Edenbridge', 1, 'edenbridge'),
(35433, 741270, 'gb', 'Faversham', 1, 'faversham'),
(35434, 741270, 'gb', 'Fawkham', 1, 'fawkham'),
(35435, 741270, 'gb', 'Folkestone', 1, 'folkestone'),
(35436, 741270, 'gb', 'Gillingham', 1, 'gillingham'),
(35437, 741270, 'gb', 'Goudhurst', 1, 'goudhurst'),
(35438, 741270, 'gb', 'Gravesend', 1, 'gravesend'),
(35439, 741270, 'gb', 'Hawkhurst', 1, 'hawkhurst'),
(35440, 741270, 'gb', 'Headcorn', 1, 'headcorn'),
(35441, 741270, 'gb', 'Herne Bay', 1, 'herne-bay'),
(35442, 741270, 'gb', 'Hever', 1, 'hever'),
(35443, 741270, 'gb', 'Hildenborough', 1, 'hildenborough'),
(35444, 741270, 'gb', 'Hollingbourne', 1, 'hollingbourne'),
(35445, 741270, 'gb', 'Hythe', 1, 'hythe'),
(35446, 741270, 'gb', 'Kent', 1, 'kent'),
(35447, 741270, 'gb', 'Lamberhurst', 1, 'lamberhurst'),
(35448, 741270, 'gb', 'Lenham', 1, 'lenham'),
(35449, 741270, 'gb', 'Lydd', 1, 'lydd'),
(35450, 741270, 'gb', 'Maidstone', 1, 'maidstone'),
(35451, 741270, 'gb', 'Manston', 1, 'manston'),
(35452, 741270, 'gb', 'Marden', 1, 'marden'),
(35453, 741270, 'gb', 'Margate', 1, 'margate'),
(35454, 741270, 'gb', 'Matfield', 1, 'matfield'),
(35455, 741270, 'gb', 'Milstead', 1, 'milstead'),
(35456, 741270, 'gb', 'New Romney', 1, 'new-romney'),
(35457, 741270, 'gb', 'Otham', 1, 'otham'),
(35458, 741270, 'gb', 'Paddock Wood', 1, 'paddock-wood'),
(35459, 741270, 'gb', 'Penshurst', 1, 'penshurst'),
(35460, 741270, 'gb', 'Rainham', 1, 'rainham'),
(35461, 741270, 'gb', 'Ramsgate', 1, 'ramsgate'),
(35462, 741270, 'gb', 'Rochester', 1, 'rochester'),
(35463, 741270, 'gb', 'Romney Marsh', 1, 'romney-marsh'),
(35464, 741270, 'gb', 'Sandhurst', 1, 'sandhurst'),
(35465, 741270, 'gb', 'Sandwich', 1, 'sandwich'),
(35466, 741270, 'gb', 'Sarre', 1, 'sarre'),
(35467, 741270, 'gb', 'Sevenoaks', 1, 'sevenoaks'),
(35468, 741270, 'gb', 'Sheerness', 1, 'sheerness'),
(35469, 741270, 'gb', 'Shoreham', 1, 'shoreham'),
(35470, 741270, 'gb', 'Sissinghurst', 1, 'sissinghurst'),
(35471, 741270, 'gb', 'Sittingbourne', 1, 'sittingbourne'),
(35472, 741270, 'gb', 'Smarden', 1, 'smarden'),
(35473, 741270, 'gb', 'Snodland', 1, 'snodland'),
(35474, 741270, 'gb', 'Southfleet', 1, 'southfleet'),
(35475, 741270, 'gb', 'Staplehurst', 1, 'staplehurst'),
(35476, 741270, 'gb', 'Stone', 1, 'stone'),
(35477, 741270, 'gb', 'Street End', 1, 'street-end'),
(35478, 741270, 'gb', 'Strood', 1, 'strood'),
(35479, 741270, 'gb', 'Sutton Valence', 1, 'sutton-valence'),
(35480, 741270, 'gb', 'Tenterden', 1, 'tenterden'),
(35481, 741270, 'gb', 'Throwley', 1, 'throwley'),
(35482, 741270, 'gb', 'Tonbridge', 1, 'tonbridge'),
(35483, 741270, 'gb', 'Tunbridge Wells', 1, 'tunbridge-wells'),
(35484, 741270, 'gb', 'Upchurch', 1, 'upchurch'),
(35485, 741270, 'gb', 'Westerham', 1, 'westerham'),
(35486, 741270, 'gb', 'Westgate-on-Sea', 1, 'westgate-on-sea'),
(35487, 741270, 'gb', 'West Malling', 1, 'west-malling'),
(35488, 741270, 'gb', 'Whitstable', 1, 'whitstable'),
(35489, 741270, 'gb', 'Wrotham', 1, 'wrotham'),
(35490, 741270, 'gb', 'Wye', 1, 'wye');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741350, 'gb', 'Lancashire', 1, 'lancashire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35491, 741350, 'gb', 'Accrington', 1, 'accrington'),
(35492, 741350, 'gb', 'Barnoldswick', 1, 'barnoldswick'),
(35493, 741350, 'gb', 'Barrowford', 1, 'barrowford'),
(35494, 741350, 'gb', 'Bilsborrow', 1, 'bilsborrow'),
(35495, 741350, 'gb', 'Blackburn', 1, 'blackburn'),
(35496, 741350, 'gb', 'Blackpool', 1, 'blackpool'),
(35497, 741350, 'gb', 'Bolton', 1, 'bolton'),
(35498, 741350, 'gb', 'Borwick', 1, 'borwick'),
(35499, 741350, 'gb', 'Broughton', 1, 'broughton'),
(35500, 741350, 'gb', 'Burnley', 1, 'burnley'),
(35501, 741350, 'gb', 'Carnforth', 1, 'carnforth'),
(35502, 741350, 'gb', 'Charnock Richard', 1, 'charnock-richard'),
(35503, 741350, 'gb', 'Cheadle', 1, 'cheadle'),
(35504, 741350, 'gb', 'Chipping', 1, 'chipping'),
(35505, 741350, 'gb', 'Chorley', 1, 'chorley'),
(35506, 741350, 'gb', 'Claughton', 1, 'claughton'),
(35507, 741350, 'gb', 'Clayton le Moors', 1, 'clayton-le-moors'),
(35508, 741350, 'gb', 'Clayton le Woods', 1, 'clayton-le-woods'),
(35509, 741350, 'gb', 'Clitheroe', 1, 'clitheroe'),
(35510, 741350, 'gb', 'Colne', 1, 'colne'),
(35511, 741350, 'gb', 'Cowan Bridge', 1, 'cowan-bridge'),
(35512, 741350, 'gb', 'Darwen', 1, 'darwen'),
(35513, 741350, 'gb', 'Fleetwood', 1, 'fleetwood'),
(35514, 741350, 'gb', 'Garstang', 1, 'garstang'),
(35515, 741350, 'gb', 'Gisburn', 1, 'gisburn'),
(35516, 741350, 'gb', 'Great Singleton', 1, 'great-singleton'),
(35517, 741350, 'gb', 'Heysham', 1, 'heysham'),
(35518, 741350, 'gb', 'Heywood', 1, 'heywood'),
(35519, 741350, 'gb', 'Hyde', 1, 'hyde'),
(35520, 741350, 'gb', 'Lancaster', 1, 'lancaster'),
(35521, 741350, 'gb', 'Lancs', 1, 'lancs'),
(35522, 741350, 'gb', 'Last Drop Village', 1, 'last-drop-village'),
(35523, 741350, 'gb', 'Leyland', 1, 'leyland'),
(35524, 741350, 'gb', 'Lytham St Annes', 1, 'lytham-st-annes'),
(35525, 741350, 'gb', 'Morecambe', 1, 'morecambe'),
(35526, 741350, 'gb', 'Nelson', 1, 'nelson'),
(35527, 741350, 'gb', 'Newhey', 1, 'newhey'),
(35528, 741350, 'gb', 'Ormskirk', 1, 'ormskirk'),
(35529, 741350, 'gb', 'Overton', 1, 'overton'),
(35530, 741350, 'gb', 'Padiham', 1, 'padiham'),
(35531, 741350, 'gb', 'Preston', 1, 'preston'),
(35532, 741350, 'gb', 'Rochdale', 1, 'rochdale'),
(35533, 741350, 'gb', 'Rossendale', 1, 'rossendale'),
(35534, 741350, 'gb', 'Saint Annes On Sea', 1, 'saint-annes-on-sea'),
(35535, 741350, 'gb', 'Sawley', 1, 'sawley'),
(35536, 741350, 'gb', 'Simonstone', 1, 'simonstone'),
(35537, 741350, 'gb', 'Skelmersdale', 1, 'skelmersdale'),
(35538, 741350, 'gb', 'Slaidburn', 1, 'slaidburn'),
(35539, 741350, 'gb', 'Street', 1, 'street'),
(35540, 741350, 'gb', 'Walton-le-Dale', 1, 'walton-le-dale'),
(35541, 741350, 'gb', 'Whiston', 1, 'whiston'),
(35542, 741350, 'gb', 'Wrightington', 1, 'wrightington');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741403, 'gb', 'Leicestershire', 1, 'leicestershire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35543, 741403, 'gb', 'Appleby Magna', 1, 'appleby-magna'),
(35544, 741403, 'gb', 'Ashby de la Zouch', 1, 'ashby-de-la-zouch'),
(35545, 741403, 'gb', 'Belvoir', 1, 'belvoir'),
(35546, 741403, 'gb', 'Coalville', 1, 'coalville'),
(35547, 741403, 'gb', 'Desford', 1, 'desford'),
(35548, 741403, 'gb', 'Enderby', 1, 'enderby'),
(35549, 741403, 'gb', 'Hinckley', 1, 'hinckley'),
(35550, 741403, 'gb', 'Husbands Bosworth', 1, 'husbands-bosworth'),
(35551, 741403, 'gb', 'Leicester', 1, 'leicester'),
(35552, 741403, 'gb', 'Loughborough', 1, 'loughborough'),
(35553, 741403, 'gb', 'Lutterworth', 1, 'lutterworth'),
(35554, 741403, 'gb', 'Market Bosworth', 1, 'market-bosworth'),
(35555, 741403, 'gb', 'Market Harborough', 1, 'market-harborough'),
(35556, 741403, 'gb', 'Markfield', 1, 'markfield'),
(35557, 741403, 'gb', 'Melton Mowbray', 1, 'melton-mowbray'),
(35558, 741403, 'gb', 'Oadby', 1, 'oadby'),
(35559, 741403, 'gb', 'Oakham', 1, 'oakham'),
(35560, 741403, 'gb', 'Packington', 1, 'packington'),
(35561, 741403, 'gb', 'Quorn', 1, 'quorn'),
(35562, 741403, 'gb', 'Rothley', 1, 'rothley'),
(35563, 741403, 'gb', 'Twycross', 1, 'twycross'),
(35564, 741403, 'gb', 'Ullesthorpe', 1, 'ullesthorpe'),
(35565, 741403, 'gb', 'Uppingham', 1, 'uppingham'),
(35566, 741403, 'gb', 'Wigston', 1, 'wigston');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741428, 'gb', 'Lincolnshire', 1, 'lincolnshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35567, 741428, 'gb', 'Alford', 1, 'alford'),
(35568, 741428, 'gb', 'Belton', 1, 'belton'),
(35569, 741428, 'gb', 'Boston', 1, 'boston'),
(35570, 741428, 'gb', 'Bourne', 1, 'bourne'),
(35571, 741428, 'gb', 'Broughton', 1, 'broughton'),
(35572, 741428, 'gb', 'Cleethorpes', 1, 'cleethorpes'),
(35573, 741428, 'gb', 'Donington', 1, 'donington'),
(35574, 741428, 'gb', 'Gainsborough', 1, 'gainsborough'),
(35575, 741428, 'gb', 'Gibraltar', 1, 'gibraltar'),
(35576, 741428, 'gb', 'Grainthorpe', 1, 'grainthorpe'),
(35577, 741428, 'gb', 'Grantham', 1, 'grantham'),
(35578, 741428, 'gb', 'Great Carlton', 1, 'great-carlton'),
(35579, 741428, 'gb', 'Great Coates', 1, 'great-coates'),
(35580, 741428, 'gb', 'Great Grimsby', 1, 'great-grimsby'),
(35581, 741428, 'gb', 'Harlaxton', 1, 'harlaxton'),
(35582, 741428, 'gb', 'HornCastle', 1, 'horncastle'),
(35583, 741428, 'gb', 'Immingham', 1, 'immingham'),
(35584, 741428, 'gb', 'Kirkby', 1, 'kirkby'),
(35585, 741428, 'gb', 'Kirkby Green', 1, 'kirkby-green'),
(35586, 741428, 'gb', 'Kirmington', 1, 'kirmington'),
(35587, 741428, 'gb', 'Laceby', 1, 'laceby'),
(35588, 741428, 'gb', 'Lincoln', 1, 'lincoln'),
(35589, 741428, 'gb', 'Louth', 1, 'louth'),
(35590, 741428, 'gb', 'Market Deeping', 1, 'market-deeping'),
(35591, 741428, 'gb', 'Market Rasen', 1, 'market-rasen'),
(35592, 741428, 'gb', 'Marton', 1, 'marton'),
(35593, 741428, 'gb', 'Sapperton', 1, 'sapperton'),
(35594, 741428, 'gb', 'Skegness', 1, 'skegness'),
(35595, 741428, 'gb', 'Sleaford', 1, 'sleaford'),
(35596, 741428, 'gb', 'Spalding', 1, 'spalding'),
(35597, 741428, 'gb', 'Stamford', 1, 'stamford'),
(35598, 741428, 'gb', 'Stoke Rochford', 1, 'stoke-rochford'),
(35599, 741428, 'gb', 'Sutton On Sea', 1, 'sutton-on-sea'),
(35600, 741428, 'gb', 'Syston', 1, 'syston'),
(35601, 741428, 'gb', 'Tetford', 1, 'tetford'),
(35602, 741428, 'gb', 'Uffington', 1, 'uffington'),
(35603, 741428, 'gb', 'Woodhall', 1, 'woodhall');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741466, 'gb', 'Merseyside', 1, 'merseyside');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35604, 741466, 'gb', 'Aintree', 1, 'aintree'),
(35605, 741466, 'gb', 'Bebington', 1, 'bebington'),
(35606, 741466, 'gb', 'Birkenhead', 1, 'birkenhead'),
(35607, 741466, 'gb', 'Bromborough', 1, 'bromborough'),
(35608, 741466, 'gb', 'Gayton', 1, 'gayton'),
(35609, 741466, 'gb', 'Haydock', 1, 'haydock'),
(35610, 741466, 'gb', 'Heswall', 1, 'heswall'),
(35611, 741466, 'gb', 'Hoylake', 1, 'hoylake'),
(35612, 741466, 'gb', 'Knowsley', 1, 'knowsley'),
(35613, 741466, 'gb', 'Liverpool', 1, 'liverpool'),
(35614, 741466, 'gb', 'Maghull', 1, 'maghull'),
(35615, 741466, 'gb', 'Port Sunlight', 1, 'port-sunlight'),
(35616, 741466, 'gb', 'Prenton', 1, 'prenton'),
(35617, 741466, 'gb', 'Prescot', 1, 'prescot'),
(35618, 741466, 'gb', 'Southport', 1, 'southport'),
(35619, 741466, 'gb', 'St. Helens', 1, 'st-helens'),
(35620, 741466, 'gb', 'Thornton Hough', 1, 'thornton-hough'),
(35621, 741466, 'gb', 'Wallasey', 1, 'wallasey'),
(35622, 741466, 'gb', 'Whiston', 1, 'whiston'),
(35623, 741466, 'gb', 'Widnes', 1, 'widnes'),
(35624, 741466, 'gb', 'Wirral', 1, 'wirral');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741488, 'gb', 'Norfolk', 1, 'norfolk');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35625, 741488, 'gb', 'Attleborough', 1, 'attleborough'),
(35626, 741488, 'gb', 'Aylsham', 1, 'aylsham'),
(35627, 741488, 'gb', 'Beeston', 1, 'beeston'),
(35628, 741488, 'gb', 'Blakeney', 1, 'blakeney'),
(35629, 741488, 'gb', 'Bressingham', 1, 'bressingham'),
(35630, 741488, 'gb', 'Cawston', 1, 'cawston'),
(35631, 741488, 'gb', 'Congham', 1, 'congham'),
(35632, 741488, 'gb', 'Diss', 1, 'diss'),
(35633, 741488, 'gb', 'Downham Market', 1, 'downham-market'),
(35634, 741488, 'gb', 'East Dereham', 1, 'east-dereham'),
(35635, 741488, 'gb', 'East Wretham', 1, 'east-wretham'),
(35636, 741488, 'gb', 'Fakenham', 1, 'fakenham'),
(35637, 741488, 'gb', 'Felbrigg', 1, 'felbrigg'),
(35638, 741488, 'gb', 'Gayton', 1, 'gayton'),
(35639, 741488, 'gb', 'Gillingham', 1, 'gillingham'),
(35640, 741488, 'gb', 'Great Yarmouth', 1, 'great-yarmouth'),
(35641, 741488, 'gb', 'Heacham', 1, 'heacham'),
(35642, 741488, 'gb', 'Hempnall', 1, 'hempnall'),
(35643, 741488, 'gb', 'Holt', 1, 'holt'),
(35644, 741488, 'gb', 'Hunstanton', 1, 'hunstanton'),
(35645, 741488, 'gb', 'King\'s Lynn', 1, 'kings-lynn'),
(35646, 741488, 'gb', 'Little Walsingham', 1, 'little-walsingham'),
(35647, 741488, 'gb', 'North Walsham', 1, 'north-walsham'),
(35648, 741488, 'gb', 'Northwold', 1, 'northwold'),
(35649, 741488, 'gb', 'Norwich', 1, 'norwich'),
(35650, 741488, 'gb', 'Old Hunstanton', 1, 'old-hunstanton'),
(35651, 741488, 'gb', 'Oxborough', 1, 'oxborough'),
(35652, 741488, 'gb', 'Reepham', 1, 'reepham'),
(35653, 741488, 'gb', 'Rollesby', 1, 'rollesby'),
(35654, 741488, 'gb', 'Scole', 1, 'scole'),
(35655, 741488, 'gb', 'Sheringham', 1, 'sheringham'),
(35656, 741488, 'gb', 'Stalham', 1, 'stalham'),
(35657, 741488, 'gb', 'Stoke By Nayland', 1, 'stoke-by-nayland'),
(35658, 741488, 'gb', 'Swaffham', 1, 'swaffham'),
(35659, 741488, 'gb', 'Swardeston', 1, 'swardeston'),
(35660, 741488, 'gb', 'Thetford', 1, 'thetford'),
(35661, 741488, 'gb', 'Thorpe Market', 1, 'thorpe-market'),
(35662, 741488, 'gb', 'Walsingham', 1, 'walsingham'),
(35663, 741488, 'gb', 'Wells Next the Sea', 1, 'wells-next-the-sea'),
(35664, 741488, 'gb', 'Wymondham', 1, 'wymondham');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741529, 'gb', 'North Yorkshire', 1, 'north-yorkshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35665, 741529, 'gb', 'Appleton le Moors', 1, 'appleton-le-moors'),
(35666, 741529, 'gb', 'Askrigg', 1, 'askrigg'),
(35667, 741529, 'gb', 'Bedale', 1, 'bedale'),
(35668, 741529, 'gb', 'Bolton Abbey', 1, 'bolton-abbey'),
(35669, 741529, 'gb', 'Boroughbridge', 1, 'boroughbridge'),
(35670, 741529, 'gb', 'Broughton', 1, 'broughton'),
(35671, 741529, 'gb', 'Castleton', 1, 'castleton'),
(35672, 741529, 'gb', 'Drax', 1, 'drax'),
(35673, 741529, 'gb', 'Dunsley', 1, 'dunsley'),
(35674, 741529, 'gb', 'Easington Lane', 1, 'easington-lane'),
(35675, 741529, 'gb', 'Easingwold', 1, 'easingwold'),
(35676, 741529, 'gb', 'Ferrensby', 1, 'ferrensby'),
(35677, 741529, 'gb', 'Filey', 1, 'filey'),
(35678, 741529, 'gb', 'Gisborough', 1, 'gisborough'),
(35679, 741529, 'gb', 'Goathland', 1, 'goathland'),
(35680, 741529, 'gb', 'Grassington', 1, 'grassington'),
(35681, 741529, 'gb', 'Grosmont', 1, 'grosmont'),
(35682, 741529, 'gb', 'Guisborough', 1, 'guisborough'),
(35683, 741529, 'gb', 'Hackness', 1, 'hackness'),
(35684, 741529, 'gb', 'Harrogate', 1, 'harrogate'),
(35685, 741529, 'gb', 'Hauxwell', 1, 'hauxwell'),
(35686, 741529, 'gb', 'Hawes', 1, 'hawes'),
(35687, 741529, 'gb', 'Hawnby', 1, 'hawnby'),
(35688, 741529, 'gb', 'Haxby', 1, 'haxby'),
(35689, 741529, 'gb', 'Helmsley', 1, 'helmsley'),
(35690, 741529, 'gb', 'Hovingham', 1, 'hovingham'),
(35691, 741529, 'gb', 'Hunmanby', 1, 'hunmanby'),
(35692, 741529, 'gb', 'Kildwick', 1, 'kildwick'),
(35693, 741529, 'gb', 'Kirkby', 1, 'kirkby'),
(35694, 741529, 'gb', 'Kirkby Fleetham', 1, 'kirkby-fleetham'),
(35695, 741529, 'gb', 'Kirkby Grindalythe', 1, 'kirkby-grindalythe'),
(35696, 741529, 'gb', 'Kirkby Malham', 1, 'kirkby-malham'),
(35697, 741529, 'gb', 'Kirkby Malzeard', 1, 'kirkby-malzeard'),
(35698, 741529, 'gb', 'Kirkby Mills', 1, 'kirkby-mills'),
(35699, 741529, 'gb', 'Kirkbymoorside', 1, 'kirkbymoorside'),
(35700, 741529, 'gb', 'Kirkby Overblow', 1, 'kirkby-overblow'),
(35701, 741529, 'gb', 'Knaresborough', 1, 'knaresborough'),
(35702, 741529, 'gb', 'Leeming Bar', 1, 'leeming-bar'),
(35703, 741529, 'gb', 'Levisham', 1, 'levisham'),
(35704, 741529, 'gb', 'Leyburn', 1, 'leyburn'),
(35705, 741529, 'gb', 'Malham', 1, 'malham'),
(35706, 741529, 'gb', 'Malton', 1, 'malton'),
(35707, 741529, 'gb', 'Masham', 1, 'masham'),
(35708, 741529, 'gb', 'Middleham', 1, 'middleham'),
(35709, 741529, 'gb', 'Middlesbrough', 1, 'middlesbrough'),
(35710, 741529, 'gb', 'Northallerton', 1, 'northallerton'),
(35711, 741529, 'gb', 'North Yorkshire', 1, 'north-yorkshire'),
(35712, 741529, 'gb', 'Norton', 1, 'norton'),
(35713, 741529, 'gb', 'Nunnington', 1, 'nunnington'),
(35714, 741529, 'gb', 'Pickering', 1, 'pickering'),
(35715, 741529, 'gb', 'Richmond', 1, 'richmond'),
(35716, 741529, 'gb', 'Ripley', 1, 'ripley'),
(35717, 741529, 'gb', 'Ripon', 1, 'ripon'),
(35718, 741529, 'gb', 'Rosedale Abbey', 1, 'rosedale-abbey'),
(35719, 741529, 'gb', 'Scarborough', 1, 'scarborough'),
(35720, 741529, 'gb', 'Selby', 1, 'selby'),
(35721, 741529, 'gb', 'Settle', 1, 'settle'),
(35722, 741529, 'gb', 'Skipton', 1, 'skipton'),
(35723, 741529, 'gb', 'South Milford', 1, 'south-milford'),
(35724, 741529, 'gb', 'Staithes', 1, 'staithes'),
(35725, 741529, 'gb', 'Staveley', 1, 'staveley'),
(35726, 741529, 'gb', 'Street', 1, 'street'),
(35727, 741529, 'gb', 'Tadcaster', 1, 'tadcaster'),
(35728, 741529, 'gb', 'Teesside', 1, 'teesside'),
(35729, 741529, 'gb', 'Thirsk', 1, 'thirsk'),
(35730, 741529, 'gb', 'West Witton', 1, 'west-witton'),
(35731, 741529, 'gb', 'Whitby', 1, 'whitby'),
(35732, 741529, 'gb', 'Wilton', 1, 'wilton'),
(35733, 741529, 'gb', 'Yarm', 1, 'yarm'),
(35734, 741529, 'gb', 'York', 1, 'york');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741600, 'gb', 'Northamptonshire', 1, 'northamptonshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35735, 741600, 'gb', 'Brackley', 1, 'brackley'),
(35736, 741600, 'gb', 'Broughton', 1, 'broughton'),
(35737, 741600, 'gb', 'Castle Ashby', 1, 'castle-ashby'),
(35738, 741600, 'gb', 'Corby', 1, 'corby'),
(35739, 741600, 'gb', 'Crick', 1, 'crick'),
(35740, 741600, 'gb', 'Daventry', 1, 'daventry'),
(35741, 741600, 'gb', 'Desborough', 1, 'desborough'),
(35742, 741600, 'gb', 'Edwinstowe', 1, 'edwinstowe'),
(35743, 741600, 'gb', 'Finedon', 1, 'finedon'),
(35744, 741600, 'gb', 'Gayton', 1, 'gayton'),
(35745, 741600, 'gb', 'Kettering', 1, 'kettering'),
(35746, 741600, 'gb', 'Kings Sutton', 1, 'kings-sutton'),
(35747, 741600, 'gb', 'Northampton', 1, 'northampton'),
(35748, 741600, 'gb', 'Oundle', 1, 'oundle'),
(35749, 741600, 'gb', 'Silverstone', 1, 'silverstone'),
(35750, 741600, 'gb', 'Southwick', 1, 'southwick'),
(35751, 741600, 'gb', 'Stoke Bruerne', 1, 'stoke-bruerne'),
(35752, 741600, 'gb', 'Thrapston', 1, 'thrapston'),
(35753, 741600, 'gb', 'Towcester Silverstone', 1, 'towcester-silverstone'),
(35754, 741600, 'gb', 'Weedon Bec', 1, 'weedon-bec'),
(35755, 741600, 'gb', 'Wellingborough', 1, 'wellingborough'),
(35756, 741600, 'gb', 'Woodford', 1, 'woodford');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741623, 'gb', 'Northumberland', 1, 'northumberland');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35757, 741623, 'gb', 'Alnwick', 1, 'alnwick'),
(35758, 741623, 'gb', 'Amble', 1, 'amble'),
(35759, 741623, 'gb', 'Bamburgh', 1, 'bamburgh'),
(35760, 741623, 'gb', 'Belford', 1, 'belford'),
(35761, 741623, 'gb', 'Berwick Upon Tweed', 1, 'berwick-upon-tweed'),
(35762, 741623, 'gb', 'Blanchland', 1, 'blanchland'),
(35763, 741623, 'gb', 'Chollerford', 1, 'chollerford'),
(35764, 741623, 'gb', 'Corbridge', 1, 'corbridge'),
(35765, 741623, 'gb', 'Cramlington', 1, 'cramlington'),
(35766, 741623, 'gb', 'Craster', 1, 'craster'),
(35767, 741623, 'gb', 'Greenhead', 1, 'greenhead'),
(35768, 741623, 'gb', 'Lexham', 1, 'lexham'),
(35769, 741623, 'gb', 'Longhorsley', 1, 'longhorsley'),
(35770, 741623, 'gb', 'Morpeth', 1, 'morpeth'),
(35771, 741623, 'gb', 'Otterburn', 1, 'otterburn'),
(35772, 741623, 'gb', 'Ponteland', 1, 'ponteland'),
(35773, 741623, 'gb', 'Powburn', 1, 'powburn'),
(35774, 741623, 'gb', 'Rock', 1, 'rock'),
(35775, 741623, 'gb', 'Rothbury', 1, 'rothbury'),
(35776, 741623, 'gb', 'Stonehouse', 1, 'stonehouse'),
(35777, 741623, 'gb', 'Wall', 1, 'wall'),
(35778, 741623, 'gb', 'Warkworth', 1, 'warkworth'),
(35779, 741623, 'gb', 'Wooler', 1, 'wooler');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741647, 'gb', 'Nottinghamshire', 1, 'nottinghamshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35780, 741647, 'gb', 'Beeston', 1, 'beeston'),
(35781, 741647, 'gb', 'Blyth', 1, 'blyth'),
(35782, 741647, 'gb', 'Claverton', 1, 'claverton'),
(35783, 741647, 'gb', 'Darlton', 1, 'darlton'),
(35784, 741647, 'gb', 'East Retford', 1, 'east-retford'),
(35785, 741647, 'gb', 'Eastwood', 1, 'eastwood'),
(35786, 741647, 'gb', 'Granby', 1, 'granby'),
(35787, 741647, 'gb', 'Harwell', 1, 'harwell'),
(35788, 741647, 'gb', 'Hucknall', 1, 'hucknall'),
(35789, 741647, 'gb', 'Kegworth', 1, 'kegworth'),
(35790, 741647, 'gb', 'Kirkby in Ashfield', 1, 'kirkby-in-ashfield'),
(35791, 741647, 'gb', 'Mansfield', 1, 'mansfield'),
(35792, 741647, 'gb', 'Newark On Trent', 1, 'newark-on-trent'),
(35793, 741647, 'gb', 'New Ollerton', 1, 'new-ollerton'),
(35794, 741647, 'gb', 'Nottingham', 1, 'nottingham'),
(35795, 741647, 'gb', 'Ollerton', 1, 'ollerton'),
(35796, 741647, 'gb', 'Retford', 1, 'retford'),
(35797, 741647, 'gb', 'Southwell', 1, 'southwell'),
(35798, 741647, 'gb', 'Sutton-in-Ashfield', 1, 'sutton-in-ashfield'),
(35799, 741647, 'gb', 'Torworth', 1, 'torworth'),
(35800, 741647, 'gb', 'West Bridgford', 1, 'west-bridgford'),
(35801, 741647, 'gb', 'Wilford', 1, 'wilford'),
(35802, 741647, 'gb', 'Worksop', 1, 'worksop');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741671, 'gb', 'Oxfordshire', 1, 'oxfordshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35803, 741671, 'gb', 'Abingdon', 1, 'abingdon'),
(35804, 741671, 'gb', 'Banbury', 1, 'banbury'),
(35805, 741671, 'gb', 'Bicester', 1, 'bicester'),
(35806, 741671, 'gb', 'Bladon', 1, 'bladon'),
(35807, 741671, 'gb', 'Bledington', 1, 'bledington'),
(35808, 741671, 'gb', 'Blenheim Palace', 1, 'blenheim-palace'),
(35809, 741671, 'gb', 'Broughton', 1, 'broughton'),
(35810, 741671, 'gb', 'Burford', 1, 'burford'),
(35811, 741671, 'gb', 'Charlbury', 1, 'charlbury'),
(35812, 741671, 'gb', 'Chinnor', 1, 'chinnor'),
(35813, 741671, 'gb', 'Chipping Norton', 1, 'chipping-norton'),
(35814, 741671, 'gb', 'Claydon', 1, 'claydon'),
(35815, 741671, 'gb', 'Cornwell', 1, 'cornwell'),
(35816, 741671, 'gb', 'Cropredy', 1, 'cropredy'),
(35817, 741671, 'gb', 'Deddington', 1, 'deddington'),
(35818, 741671, 'gb', 'Didcot', 1, 'didcot'),
(35819, 741671, 'gb', 'Dorchester', 1, 'dorchester'),
(35820, 741671, 'gb', 'Duns Tew', 1, 'duns-tew'),
(35821, 741671, 'gb', 'Enstone', 1, 'enstone'),
(35822, 741671, 'gb', 'Faringdon', 1, 'faringdon'),
(35823, 741671, 'gb', 'Garsington', 1, 'garsington'),
(35824, 741671, 'gb', 'Great Milton', 1, 'great-milton'),
(35825, 741671, 'gb', 'Greenfield', 1, 'greenfield'),
(35826, 741671, 'gb', 'Harwell', 1, 'harwell'),
(35827, 741671, 'gb', 'Henley On Thames', 1, 'henley-on-thames'),
(35828, 741671, 'gb', 'Kelmscott', 1, 'kelmscott'),
(35829, 741671, 'gb', 'Kidlington', 1, 'kidlington'),
(35830, 741671, 'gb', 'Kingham', 1, 'kingham'),
(35831, 741671, 'gb', 'Kingston Bagpuize', 1, 'kingston-bagpuize'),
(35832, 741671, 'gb', 'Mapledurham', 1, 'mapledurham'),
(35833, 741671, 'gb', 'Middleton Stoney', 1, 'middleton-stoney'),
(35834, 741671, 'gb', 'Milton Common', 1, 'milton-common'),
(35835, 741671, 'gb', 'Minster Lovell', 1, 'minster-lovell'),
(35836, 741671, 'gb', 'Oxford', 1, 'oxford'),
(35837, 741671, 'gb', 'Pusey', 1, 'pusey'),
(35838, 741671, 'gb', 'Radcot', 1, 'radcot'),
(35839, 741671, 'gb', 'Salford', 1, 'salford'),
(35840, 741671, 'gb', 'Shipton on Cherwell', 1, 'shipton-on-cherwell'),
(35841, 741671, 'gb', 'Stanford in the Vale', 1, 'stanford-in-the-vale'),
(35842, 741671, 'gb', 'Stanton Harcourt', 1, 'stanton-harcourt'),
(35843, 741671, 'gb', 'Steeple Aston', 1, 'steeple-aston'),
(35844, 741671, 'gb', 'Steventon', 1, 'steventon'),
(35845, 741671, 'gb', 'Sutton Courtenay', 1, 'sutton-courtenay'),
(35846, 741671, 'gb', 'Swalciffe', 1, 'swalciffe'),
(35847, 741671, 'gb', 'Swinbrook', 1, 'swinbrook'),
(35848, 741671, 'gb', 'Sydenham', 1, 'sydenham'),
(35849, 741671, 'gb', 'Thame', 1, 'thame'),
(35850, 741671, 'gb', 'Uffington', 1, 'uffington'),
(35851, 741671, 'gb', 'Wallingford', 1, 'wallingford'),
(35852, 741671, 'gb', 'Wantage', 1, 'wantage'),
(35853, 741671, 'gb', 'Waterperry', 1, 'waterperry'),
(35854, 741671, 'gb', 'Wheatley', 1, 'wheatley'),
(35855, 741671, 'gb', 'Witney', 1, 'witney'),
(35856, 741671, 'gb', 'Woodstock', 1, 'woodstock'),
(35857, 741671, 'gb', 'Wroxton', 1, 'wroxton');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741727, 'gb', 'Rutland', 1, 'rutland');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35858, 741727, 'gb', 'Cottesmore', 1, 'cottesmore'),
(35859, 741727, 'gb', 'Glaston', 1, 'glaston');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741730, 'gb', 'Shropshire', 1, 'shropshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35860, 741730, 'gb', 'Albrighton', 1, 'albrighton'),
(35861, 741730, 'gb', 'Bridgnorth', 1, 'bridgnorth'),
(35862, 741730, 'gb', 'Church Stretton', 1, 'church-stretton'),
(35863, 741730, 'gb', 'Cleobury Mortimer', 1, 'cleobury-mortimer'),
(35864, 741730, 'gb', 'Craven Arms', 1, 'craven-arms'),
(35865, 741730, 'gb', 'Donnington', 1, 'donnington'),
(35866, 741730, 'gb', 'Ironbridge', 1, 'ironbridge'),
(35867, 741730, 'gb', 'Kenley', 1, 'kenley'),
(35868, 741730, 'gb', 'Lilleshall', 1, 'lilleshall'),
(35869, 741730, 'gb', 'Ludlow', 1, 'ludlow'),
(35870, 741730, 'gb', 'Market Drayton', 1, 'market-drayton'),
(35871, 741730, 'gb', 'Marton', 1, 'marton'),
(35872, 741730, 'gb', 'Much Wenlock', 1, 'much-wenlock'),
(35873, 741730, 'gb', 'Newport', 1, 'newport'),
(35874, 741730, 'gb', 'Northwood', 1, 'northwood'),
(35875, 741730, 'gb', 'Oswestry', 1, 'oswestry'),
(35876, 741730, 'gb', 'Shifnal', 1, 'shifnal'),
(35877, 741730, 'gb', 'Shrewsbury', 1, 'shrewsbury'),
(35878, 741730, 'gb', 'St Martins', 1, 'st-martins'),
(35879, 741730, 'gb', 'Telford', 1, 'telford'),
(35880, 741730, 'gb', 'Uffington', 1, 'uffington'),
(35881, 741730, 'gb', 'Wellington', 1, 'wellington'),
(35882, 741730, 'gb', 'Whitchurch', 1, 'whitchurch');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741754, 'gb', 'Somerset', 1, 'somerset');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35883, 741754, 'gb', 'Alcombe', 1, 'alcombe'),
(35884, 741754, 'gb', 'Axbridge', 1, 'axbridge'),
(35885, 741754, 'gb', 'Barrington', 1, 'barrington'),
(35886, 741754, 'gb', 'Bath', 1, 'bath'),
(35887, 741754, 'gb', 'Brent Knoll', 1, 'brent-knoll'),
(35888, 741754, 'gb', 'Bridgwater', 1, 'bridgwater'),
(35889, 741754, 'gb', 'Bruton', 1, 'bruton'),
(35890, 741754, 'gb', 'Burnham On Sea', 1, 'burnham-on-sea'),
(35891, 741754, 'gb', 'Castle Cary', 1, 'castle-cary'),
(35892, 741754, 'gb', 'Chapel Allerton', 1, 'chapel-allerton'),
(35893, 741754, 'gb', 'Chard', 1, 'chard'),
(35894, 741754, 'gb', 'Cheddar', 1, 'cheddar'),
(35895, 741754, 'gb', 'Cheddon Fitzpain', 1, 'cheddon-fitzpain'),
(35896, 741754, 'gb', 'Chewton Mendip', 1, 'chewton-mendip'),
(35897, 741754, 'gb', 'Chilcompton', 1, 'chilcompton'),
(35898, 741754, 'gb', 'Chiltington', 1, 'chiltington'),
(35899, 741754, 'gb', 'Claverton', 1, 'claverton'),
(35900, 741754, 'gb', 'Crewkerne', 1, 'crewkerne'),
(35901, 741754, 'gb', 'Dulverton', 1, 'dulverton'),
(35902, 741754, 'gb', 'Dunster', 1, 'dunster'),
(35903, 741754, 'gb', 'East Brent', 1, 'east-brent'),
(35904, 741754, 'gb', 'East Lambrook', 1, 'east-lambrook'),
(35905, 741754, 'gb', 'Exford', 1, 'exford'),
(35906, 741754, 'gb', 'Frome', 1, 'frome'),
(35907, 741754, 'gb', 'Glastonbury', 1, 'glastonbury'),
(35908, 741754, 'gb', 'Hawkridge', 1, 'hawkridge'),
(35909, 741754, 'gb', 'Heathfield', 1, 'heathfield'),
(35910, 741754, 'gb', 'Highbridge', 1, 'highbridge'),
(35911, 741754, 'gb', 'Ilminster', 1, 'ilminster'),
(35912, 741754, 'gb', 'Kilve', 1, 'kilve'),
(35913, 741754, 'gb', 'Kingsdon', 1, 'kingsdon'),
(35914, 741754, 'gb', 'Langport', 1, 'langport'),
(35915, 741754, 'gb', 'Limpley Stoke', 1, 'limpley-stoke'),
(35916, 741754, 'gb', 'Loxton', 1, 'loxton'),
(35917, 741754, 'gb', 'Martock', 1, 'martock'),
(35918, 741754, 'gb', 'Minehead', 1, 'minehead'),
(35919, 741754, 'gb', 'Montacute', 1, 'montacute'),
(35920, 741754, 'gb', 'Norton St. Philip', 1, 'norton-st-philip'),
(35921, 741754, 'gb', 'Porlock', 1, 'porlock'),
(35922, 741754, 'gb', 'Selworthy', 1, 'selworthy'),
(35923, 741754, 'gb', 'Shepton Mallet', 1, 'shepton-mallet'),
(35924, 741754, 'gb', 'Simonsbath', 1, 'simonsbath'),
(35925, 741754, 'gb', 'Ston Easton', 1, 'ston-easton'),
(35926, 741754, 'gb', 'Street', 1, 'street'),
(35927, 741754, 'gb', 'Street On the Fosse', 1, 'street-on-the-fosse'),
(35928, 741754, 'gb', 'Taunton', 1, 'taunton'),
(35929, 741754, 'gb', 'Tintinhull', 1, 'tintinhull'),
(35930, 741754, 'gb', 'Wanstrow', 1, 'wanstrow'),
(35931, 741754, 'gb', 'Wedmore', 1, 'wedmore'),
(35932, 741754, 'gb', 'Wells', 1, 'wells'),
(35933, 741754, 'gb', 'Weston Super Mare', 1, 'weston-super-mare'),
(35934, 741754, 'gb', 'Williton', 1, 'williton'),
(35935, 741754, 'gb', 'Wilton', 1, 'wilton'),
(35936, 741754, 'gb', 'Wincanton', 1, 'wincanton'),
(35937, 741754, 'gb', 'Wiveliscombe', 1, 'wiveliscombe'),
(35938, 741754, 'gb', 'Wootton Courtenay', 1, 'wootton-courtenay'),
(35939, 741754, 'gb', 'Yeovil', 1, 'yeovil');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741812, 'gb', 'South Yorkshire', 1, 'south-yorkshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35940, 741812, 'gb', 'Ardsley', 1, 'ardsley'),
(35941, 741812, 'gb', 'Barnsley', 1, 'barnsley'),
(35942, 741812, 'gb', 'Bawtry', 1, 'bawtry'),
(35943, 741812, 'gb', 'Denaby Main', 1, 'denaby-main'),
(35944, 741812, 'gb', 'Doncaster', 1, 'doncaster'),
(35945, 741812, 'gb', 'Rotherham', 1, 'rotherham'),
(35946, 741812, 'gb', 'Sheffield', 1, 'sheffield'),
(35947, 741812, 'gb', 'Tankersley', 1, 'tankersley'),
(35948, 741812, 'gb', 'Todwick', 1, 'todwick'),
(35949, 741812, 'gb', 'Woodall', 1, 'woodall');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741823, 'gb', 'Staffordshire', 1, 'staffordshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35950, 741823, 'gb', 'Biddulph', 1, 'biddulph'),
(35951, 741823, 'gb', 'Burntwood', 1, 'burntwood'),
(35952, 741823, 'gb', 'Burslem', 1, 'burslem'),
(35953, 741823, 'gb', 'Burton On Trent', 1, 'burton-on-trent'),
(35954, 741823, 'gb', 'Cannock', 1, 'cannock'),
(35955, 741823, 'gb', 'Cannock Wood', 1, 'cannock-wood'),
(35956, 741823, 'gb', 'Denstone', 1, 'denstone'),
(35957, 741823, 'gb', 'Gayton', 1, 'gayton'),
(35958, 741823, 'gb', 'Hanley', 1, 'hanley'),
(35959, 741823, 'gb', 'Hednesford', 1, 'hednesford'),
(35960, 741823, 'gb', 'Keele', 1, 'keele'),
(35961, 741823, 'gb', 'Leek', 1, 'leek'),
(35962, 741823, 'gb', 'Lichfield', 1, 'lichfield'),
(35963, 741823, 'gb', 'Madeley', 1, 'madeley'),
(35964, 741823, 'gb', 'Milford', 1, 'milford'),
(35965, 741823, 'gb', 'Moreton', 1, 'moreton'),
(35966, 741823, 'gb', 'Newcastle Under Lyme', 1, 'newcastle-under-lyme'),
(35967, 741823, 'gb', 'Norbury', 1, 'norbury'),
(35968, 741823, 'gb', 'Norton Canes', 1, 'norton-canes'),
(35969, 741823, 'gb', 'Penkridge', 1, 'penkridge'),
(35970, 741823, 'gb', 'Rocester', 1, 'rocester'),
(35971, 741823, 'gb', 'Rudyard', 1, 'rudyard'),
(35972, 741823, 'gb', 'Rugeley', 1, 'rugeley'),
(35973, 741823, 'gb', 'Stafford', 1, 'stafford'),
(35974, 741823, 'gb', 'Stanley', 1, 'stanley'),
(35975, 741823, 'gb', 'Stoke On Trent', 1, 'stoke-on-trent'),
(35976, 741823, 'gb', 'Stone', 1, 'stone'),
(35977, 741823, 'gb', 'Stourton', 1, 'stourton'),
(35978, 741823, 'gb', 'Tamworth', 1, 'tamworth'),
(35979, 741823, 'gb', 'Uttoxeter', 1, 'uttoxeter'),
(35980, 741823, 'gb', 'Wall', 1, 'wall'),
(35981, 741823, 'gb', 'Yoxall', 1, 'yoxall');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741856, 'gb', 'Suffolk', 1, 'suffolk');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(35982, 741856, 'gb', 'Aldeburgh', 1, 'aldeburgh'),
(35983, 741856, 'gb', 'Barking', 1, 'barking'),
(35984, 741856, 'gb', 'Beccles', 1, 'beccles'),
(35985, 741856, 'gb', 'Bentley', 1, 'bentley'),
(35986, 741856, 'gb', 'Brandeston', 1, 'brandeston'),
(35987, 741856, 'gb', 'Brandon', 1, 'brandon'),
(35988, 741856, 'gb', 'Bungay', 1, 'bungay'),
(35989, 741856, 'gb', 'Bures', 1, 'bures'),
(35990, 741856, 'gb', 'Bury St. Edmunds', 1, 'bury-st-edmunds'),
(35991, 741856, 'gb', 'Clare', 1, 'clare'),
(35992, 741856, 'gb', 'Denham', 1, 'denham'),
(35993, 741856, 'gb', 'East Bergholt', 1, 'east-bergholt'),
(35994, 741856, 'gb', 'Eye', 1, 'eye'),
(35995, 741856, 'gb', 'Felixstowe', 1, 'felixstowe'),
(35996, 741856, 'gb', 'Framlingham', 1, 'framlingham'),
(35997, 741856, 'gb', 'Halesworth', 1, 'halesworth'),
(35998, 741856, 'gb', 'Haverhill', 1, 'haverhill'),
(35999, 741856, 'gb', 'Helmingham', 1, 'helmingham'),
(36000, 741856, 'gb', 'Hintlesham', 1, 'hintlesham'),
(36001, 741856, 'gb', 'Horringer', 1, 'horringer'),
(36002, 741856, 'gb', 'Ipswich', 1, 'ipswich'),
(36003, 741856, 'gb', 'Ixworth', 1, 'ixworth'),
(36004, 741856, 'gb', 'Kersey', 1, 'kersey'),
(36005, 741856, 'gb', 'Lavenham', 1, 'lavenham'),
(36006, 741856, 'gb', 'Leiston', 1, 'leiston'),
(36007, 741856, 'gb', 'Long Melford', 1, 'long-melford'),
(36008, 741856, 'gb', 'Lowestoft', 1, 'lowestoft'),
(36009, 741856, 'gb', 'Mildenhall', 1, 'mildenhall'),
(36010, 741856, 'gb', 'Newmarket', 1, 'newmarket'),
(36011, 741856, 'gb', 'Nowton', 1, 'nowton'),
(36012, 741856, 'gb', 'Orford', 1, 'orford'),
(36013, 741856, 'gb', 'Reydon', 1, 'reydon'),
(36014, 741856, 'gb', 'Saxmundham', 1, 'saxmundham'),
(36015, 741856, 'gb', 'Sizewell', 1, 'sizewell'),
(36016, 741856, 'gb', 'Southwold', 1, 'southwold'),
(36017, 741856, 'gb', 'Stowmarket', 1, 'stowmarket'),
(36018, 741856, 'gb', 'Sudbury', 1, 'sudbury'),
(36019, 741856, 'gb', 'Thornham Magna', 1, 'thornham-magna'),
(36020, 741856, 'gb', 'Ufford', 1, 'ufford'),
(36021, 741856, 'gb', 'Woodbridge', 1, 'woodbridge'),
(36022, 741856, 'gb', 'Worlingworth', 1, 'worlingworth'),
(36023, 741856, 'gb', 'Yoxford', 1, 'yoxford');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741899, 'gb', 'Surrey', 1, 'surrey');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36024, 741899, 'gb', 'Addlestone', 1, 'addlestone'),
(36025, 741899, 'gb', 'Ashtead', 1, 'ashtead'),
(36026, 741899, 'gb', 'Bagshot', 1, 'bagshot'),
(36027, 741899, 'gb', 'Bisley', 1, 'bisley'),
(36028, 741899, 'gb', 'Byfleet', 1, 'byfleet'),
(36029, 741899, 'gb', 'Camberley', 1, 'camberley'),
(36030, 741899, 'gb', 'Caterham', 1, 'caterham'),
(36031, 741899, 'gb', 'Cobham', 1, 'cobham'),
(36032, 741899, 'gb', 'Compton', 1, 'compton'),
(36033, 741899, 'gb', 'Cranleigh', 1, 'cranleigh'),
(36034, 741899, 'gb', 'Dorking', 1, 'dorking'),
(36035, 741899, 'gb', 'East Molesey', 1, 'east-molesey'),
(36036, 741899, 'gb', 'Egham', 1, 'egham'),
(36037, 741899, 'gb', 'Ellens Green', 1, 'ellens-green'),
(36038, 741899, 'gb', 'Epsom', 1, 'epsom'),
(36039, 741899, 'gb', 'Esher', 1, 'esher'),
(36040, 741899, 'gb', 'Farleigh', 1, 'farleigh'),
(36041, 741899, 'gb', 'Farnham', 1, 'farnham'),
(36042, 741899, 'gb', 'Frimley', 1, 'frimley'),
(36043, 741899, 'gb', 'Godalming', 1, 'godalming'),
(36044, 741899, 'gb', 'Godstone', 1, 'godstone'),
(36045, 741899, 'gb', 'Guildford', 1, 'guildford'),
(36046, 741899, 'gb', 'Hambledon', 1, 'hambledon'),
(36047, 741899, 'gb', 'Hampton Court', 1, 'hampton-court'),
(36048, 741899, 'gb', 'Haslemere', 1, 'haslemere'),
(36049, 741899, 'gb', 'Headley', 1, 'headley'),
(36050, 741899, 'gb', 'Hindhead', 1, 'hindhead'),
(36051, 741899, 'gb', 'Holmbury St Mary', 1, 'holmbury-st-mary'),
(36052, 741899, 'gb', 'Horley', 1, 'horley'),
(36053, 741899, 'gb', 'Leatherhead', 1, 'leatherhead'),
(36054, 741899, 'gb', 'Little Bookham', 1, 'little-bookham'),
(36055, 741899, 'gb', 'Long Ditton', 1, 'long-ditton'),
(36056, 741899, 'gb', 'Milford', 1, 'milford'),
(36057, 741899, 'gb', 'Newdigate', 1, 'newdigate'),
(36058, 741899, 'gb', 'Ockley', 1, 'ockley'),
(36059, 741899, 'gb', 'Ottershaw', 1, 'ottershaw'),
(36060, 741899, 'gb', 'Oxted', 1, 'oxted'),
(36061, 741899, 'gb', 'Peaslake', 1, 'peaslake'),
(36062, 741899, 'gb', 'Redhill', 1, 'redhill'),
(36063, 741899, 'gb', 'Reigate', 1, 'reigate'),
(36064, 741899, 'gb', 'Richmond', 1, 'richmond'),
(36065, 741899, 'gb', 'Sanderstead', 1, 'sanderstead'),
(36066, 741899, 'gb', 'Seale', 1, 'seale'),
(36067, 741899, 'gb', 'Shepperton', 1, 'shepperton'),
(36068, 741899, 'gb', 'Smallfield', 1, 'smallfield'),
(36069, 741899, 'gb', 'Staines', 1, 'staines'),
(36070, 741899, 'gb', 'Stanwell', 1, 'stanwell'),
(36071, 741899, 'gb', 'Surbiton', 1, 'surbiton'),
(36072, 741899, 'gb', 'Tadworth', 1, 'tadworth'),
(36073, 741899, 'gb', 'Thames Ditton', 1, 'thames-ditton'),
(36074, 741899, 'gb', 'Thornton Heath', 1, 'thornton-heath'),
(36075, 741899, 'gb', 'Virginia Water', 1, 'virginia-water'),
(36076, 741899, 'gb', 'Walton on Thames', 1, 'walton-on-thames'),
(36077, 741899, 'gb', 'West Byfleet', 1, 'west-byfleet'),
(36078, 741899, 'gb', 'West Horsley', 1, 'west-horsley'),
(36079, 741899, 'gb', 'Weybridge', 1, 'weybridge'),
(36080, 741899, 'gb', 'Windlesham', 1, 'windlesham'),
(36081, 741899, 'gb', 'Wisley', 1, 'wisley'),
(36082, 741899, 'gb', 'Woking', 1, 'woking'),
(36083, 741899, 'gb', 'Woldingham', 1, 'woldingham'),
(36084, 741899, 'gb', 'Wormley', 1, 'wormley'),
(36085, 741899, 'gb', 'Wotton', 1, 'wotton');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741962, 'gb', 'Tyne y Wear', 1, 'tyne-y-wear');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36086, 741962, 'gb', 'Allensford', 1, 'allensford'),
(36087, 741962, 'gb', 'Boldon', 1, 'boldon'),
(36088, 741962, 'gb', 'Gateshead', 1, 'gateshead'),
(36089, 741962, 'gb', 'Gosforth', 1, 'gosforth'),
(36090, 741962, 'gb', 'Newcastle', 1, 'newcastle'),
(36091, 741962, 'gb', 'South Shields', 1, 'south-shields'),
(36092, 741962, 'gb', 'Sunderland', 1, 'sunderland'),
(36093, 741962, 'gb', 'Tynemouth', 1, 'tynemouth'),
(36094, 741962, 'gb', 'Wallsend', 1, 'wallsend'),
(36095, 741962, 'gb', 'Washington', 1, 'washington'),
(36096, 741962, 'gb', 'Whitley Bay', 1, 'whitley-bay');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(741974, 'gb', 'Warwickshire', 1, 'warwickshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36097, 741974, 'gb', 'Abbot\'s Salford', 1, 'abbots-salford'),
(36098, 741974, 'gb', 'Alcester', 1, 'alcester'),
(36099, 741974, 'gb', 'Alderminster', 1, 'alderminster'),
(36100, 741974, 'gb', 'Ansty', 1, 'ansty'),
(36101, 741974, 'gb', 'Atherstone', 1, 'atherstone'),
(36102, 741974, 'gb', 'Attleborough', 1, 'attleborough'),
(36103, 741974, 'gb', 'Barford', 1, 'barford'),
(36104, 741974, 'gb', 'Bearley', 1, 'bearley'),
(36105, 741974, 'gb', 'Bulkington', 1, 'bulkington'),
(36106, 741974, 'gb', 'Charlecote', 1, 'charlecote'),
(36107, 741974, 'gb', 'Cosford', 1, 'cosford'),
(36108, 741974, 'gb', 'Exhall', 1, 'exhall'),
(36109, 741974, 'gb', 'Gaydon', 1, 'gaydon'),
(36110, 741974, 'gb', 'Haseley', 1, 'haseley'),
(36111, 741974, 'gb', 'Kenilworth', 1, 'kenilworth'),
(36112, 741974, 'gb', 'Kingsbury', 1, 'kingsbury'),
(36113, 741974, 'gb', 'Lea Marston', 1, 'lea-marston'),
(36114, 741974, 'gb', 'Leamington Spa', 1, 'leamington-spa'),
(36115, 741974, 'gb', 'Lighthorne', 1, 'lighthorne'),
(36116, 741974, 'gb', 'Longbridge', 1, 'longbridge'),
(36117, 741974, 'gb', 'Marlow-on-Thames', 1, 'marlow-on-thames'),
(36118, 741974, 'gb', 'Marton', 1, 'marton'),
(36119, 741974, 'gb', 'Meriden', 1, 'meriden'),
(36120, 741974, 'gb', 'Nuneaton', 1, 'nuneaton'),
(36121, 741974, 'gb', 'Rugby', 1, 'rugby'),
(36122, 741974, 'gb', 'Shipston on Stour', 1, 'shipston-on-stour'),
(36123, 741974, 'gb', 'Stoneleigh', 1, 'stoneleigh'),
(36124, 741974, 'gb', 'Stourton', 1, 'stourton'),
(36125, 741974, 'gb', 'Stratford Upon Avon', 1, 'stratford-upon-avon'),
(36126, 741974, 'gb', 'Studley', 1, 'studley'),
(36127, 741974, 'gb', 'Warwick', 1, 'warwick'),
(36128, 741974, 'gb', 'Welford On Avon', 1, 'welford-on-avon'),
(36129, 741974, 'gb', 'Wellesbourne', 1, 'wellesbourne'),
(36130, 741974, 'gb', 'Whichford', 1, 'whichford'),
(36131, 741974, 'gb', 'Wishaw', 1, 'wishaw');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(742010, 'gb', 'West Midlands', 1, 'west-midlands');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36132, 742010, 'gb', 'Albridge', 1, 'albridge'),
(36133, 742010, 'gb', 'Allesley', 1, 'allesley'),
(36134, 742010, 'gb', 'Berkswell', 1, 'berkswell'),
(36135, 742010, 'gb', 'Birmingham', 1, 'birmingham'),
(36136, 742010, 'gb', 'Bloxwich', 1, 'bloxwich'),
(36137, 742010, 'gb', 'Bournville', 1, 'bournville'),
(36138, 742010, 'gb', 'Brierley Hill', 1, 'brierley-hill'),
(36139, 742010, 'gb', 'Coleshill', 1, 'coleshill'),
(36140, 742010, 'gb', 'Coventry', 1, 'coventry'),
(36141, 742010, 'gb', 'Dudley', 1, 'dudley'),
(36142, 742010, 'gb', 'Edgbaston', 1, 'edgbaston'),
(36143, 742010, 'gb', 'Erdington', 1, 'erdington'),
(36144, 742010, 'gb', 'Halesowen', 1, 'halesowen'),
(36145, 742010, 'gb', 'Henley in Arden', 1, 'henley-in-arden'),
(36146, 742010, 'gb', 'Hockley Heath', 1, 'hockley-heath'),
(36147, 742010, 'gb', 'Longbridge', 1, 'longbridge'),
(36148, 742010, 'gb', 'Meriden', 1, 'meriden'),
(36149, 742010, 'gb', 'Oldbury', 1, 'oldbury'),
(36150, 742010, 'gb', 'Solihull', 1, 'solihull'),
(36151, 742010, 'gb', 'Stourbridge', 1, 'stourbridge'),
(36152, 742010, 'gb', 'Sutton Coldfield', 1, 'sutton-coldfield'),
(36153, 742010, 'gb', 'Walsall', 1, 'walsall'),
(36154, 742010, 'gb', 'West Bromwich', 1, 'west-bromwich'),
(36155, 742010, 'gb', 'Wolverhampton', 1, 'wolverhampton');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(742036, 'gb', 'West Sussex', 1, 'west-sussex');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36156, 742036, 'gb', 'Albourne', 1, 'albourne'),
(36157, 742036, 'gb', 'Amberley', 1, 'amberley'),
(36158, 742036, 'gb', 'Ansty', 1, 'ansty'),
(36159, 742036, 'gb', 'Ardingly', 1, 'ardingly'),
(36160, 742036, 'gb', 'Arundel', 1, 'arundel'),
(36161, 742036, 'gb', 'Ashington', 1, 'ashington'),
(36162, 742036, 'gb', 'Balcombe', 1, 'balcombe'),
(36163, 742036, 'gb', 'Billinghurst', 1, 'billinghurst'),
(36164, 742036, 'gb', 'Birdham', 1, 'birdham'),
(36165, 742036, 'gb', 'Bodiam', 1, 'bodiam'),
(36166, 742036, 'gb', 'Bognor Regis', 1, 'bognor-regis'),
(36167, 742036, 'gb', 'Bolney', 1, 'bolney'),
(36168, 742036, 'gb', 'Burgess Hill', 1, 'burgess-hill'),
(36169, 742036, 'gb', 'Burpham', 1, 'burpham'),
(36170, 742036, 'gb', 'Chichester', 1, 'chichester'),
(36171, 742036, 'gb', 'Climping', 1, 'climping'),
(36172, 742036, 'gb', 'Compton', 1, 'compton'),
(36173, 742036, 'gb', 'Copsale', 1, 'copsale'),
(36174, 742036, 'gb', 'Copthorne', 1, 'copthorne'),
(36175, 742036, 'gb', 'Crawley', 1, 'crawley'),
(36176, 742036, 'gb', 'Cuckfield', 1, 'cuckfield'),
(36177, 742036, 'gb', 'Donnington', 1, 'donnington'),
(36178, 742036, 'gb', 'East Grinstead', 1, 'east-grinstead'),
(36179, 742036, 'gb', 'East Preston', 1, 'east-preston'),
(36180, 742036, 'gb', 'Fontwell', 1, 'fontwell'),
(36181, 742036, 'gb', 'Gatwick', 1, 'gatwick'),
(36182, 742036, 'gb', 'Greatham', 1, 'greatham'),
(36183, 742036, 'gb', 'Grinstead', 1, 'grinstead'),
(36184, 742036, 'gb', 'Handcross', 1, 'handcross'),
(36185, 742036, 'gb', 'Hassocks', 1, 'hassocks'),
(36186, 742036, 'gb', 'Haywards Heath', 1, 'haywards-heath'),
(36187, 742036, 'gb', 'Henfield', 1, 'henfield'),
(36188, 742036, 'gb', 'Hickstead', 1, 'hickstead'),
(36189, 742036, 'gb', 'Horsham', 1, 'horsham'),
(36190, 742036, 'gb', 'Horsted Keynes', 1, 'horsted-keynes'),
(36191, 742036, 'gb', 'Lancing', 1, 'lancing'),
(36192, 742036, 'gb', 'Littlehampton', 1, 'littlehampton'),
(36193, 742036, 'gb', 'Lower Beeding', 1, 'lower-beeding'),
(36194, 742036, 'gb', 'Midhurst', 1, 'midhurst'),
(36195, 742036, 'gb', 'Petworth', 1, 'petworth'),
(36196, 742036, 'gb', 'Pulborough', 1, 'pulborough'),
(36197, 742036, 'gb', 'Rudgwick', 1, 'rudgwick'),
(36198, 742036, 'gb', 'Rusper', 1, 'rusper'),
(36199, 742036, 'gb', 'Singleton', 1, 'singleton'),
(36200, 742036, 'gb', 'Southwater', 1, 'southwater'),
(36201, 742036, 'gb', 'Southwick', 1, 'southwick'),
(36202, 742036, 'gb', 'Steyning', 1, 'steyning'),
(36203, 742036, 'gb', 'Storrington', 1, 'storrington'),
(36204, 742036, 'gb', 'Street End', 1, 'street-end'),
(36205, 742036, 'gb', 'Sutton', 1, 'sutton'),
(36206, 742036, 'gb', 'Turners Hill', 1, 'turners-hill'),
(36207, 742036, 'gb', 'Worthing', 1, 'worthing');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(742089, 'gb', 'West Yorkshire', 1, 'west-yorkshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36208, 742089, 'gb', 'Batley', 1, 'batley'),
(36209, 742089, 'gb', 'Bingley', 1, 'bingley'),
(36210, 742089, 'gb', 'Birkenshaw', 1, 'birkenshaw'),
(36211, 742089, 'gb', 'Boston Spa', 1, 'boston-spa'),
(36212, 742089, 'gb', 'Bradford', 1, 'bradford'),
(36213, 742089, 'gb', 'Bramhope', 1, 'bramhope'),
(36214, 742089, 'gb', 'Brighouse', 1, 'brighouse'),
(36215, 742089, 'gb', 'Castleford', 1, 'castleford'),
(36216, 742089, 'gb', 'Cleckheaton', 1, 'cleckheaton'),
(36217, 742089, 'gb', 'Dewsbury', 1, 'dewsbury'),
(36218, 742089, 'gb', 'Farsley', 1, 'farsley'),
(36219, 742089, 'gb', 'Garforth', 1, 'garforth'),
(36220, 742089, 'gb', 'Gomersal', 1, 'gomersal'),
(36221, 742089, 'gb', 'Guiseley', 1, 'guiseley'),
(36222, 742089, 'gb', 'Halifax', 1, 'halifax'),
(36223, 742089, 'gb', 'Harewood', 1, 'harewood'),
(36224, 742089, 'gb', 'Hartshead Moor', 1, 'hartshead-moor'),
(36225, 742089, 'gb', 'Haworth', 1, 'haworth'),
(36226, 742089, 'gb', 'Hebden Bridge', 1, 'hebden-bridge'),
(36227, 742089, 'gb', 'Heckmondwike', 1, 'heckmondwike'),
(36228, 742089, 'gb', 'Hipperholme', 1, 'hipperholme'),
(36229, 742089, 'gb', 'Holmfirth', 1, 'holmfirth'),
(36230, 742089, 'gb', 'Huddersfield', 1, 'huddersfield'),
(36231, 742089, 'gb', 'Ilkley', 1, 'ilkley'),
(36232, 742089, 'gb', 'Ingrow', 1, 'ingrow'),
(36233, 742089, 'gb', 'Keighley', 1, 'keighley'),
(36234, 742089, 'gb', 'Kippax', 1, 'kippax'),
(36235, 742089, 'gb', 'Kirkburton', 1, 'kirkburton'),
(36236, 742089, 'gb', 'Leeds', 1, 'leeds'),
(36237, 742089, 'gb', 'Linton', 1, 'linton'),
(36238, 742089, 'gb', 'Liversedge', 1, 'liversedge'),
(36239, 742089, 'gb', 'Mirfield', 1, 'mirfield'),
(36240, 742089, 'gb', 'Normanton', 1, 'normanton'),
(36241, 742089, 'gb', 'Ossett', 1, 'ossett'),
(36242, 742089, 'gb', 'Otley', 1, 'otley'),
(36243, 742089, 'gb', 'Oulton', 1, 'oulton'),
(36244, 742089, 'gb', 'Pontefract', 1, 'pontefract'),
(36245, 742089, 'gb', 'Pudsey', 1, 'pudsey'),
(36246, 742089, 'gb', 'Shipley', 1, 'shipley'),
(36247, 742089, 'gb', 'Sowerby Bridge', 1, 'sowerby-bridge'),
(36248, 742089, 'gb', 'Wakefield', 1, 'wakefield'),
(36249, 742089, 'gb', 'Wetherby', 1, 'wetherby'),
(36250, 742089, 'gb', 'Woodwetherby', 1, 'woodwetherby');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(742134, 'gb', 'Wiltshire', 1, 'wiltshire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36251, 742134, 'gb', 'Amesbury', 1, 'amesbury'),
(36252, 742134, 'gb', 'Ansty', 1, 'ansty'),
(36253, 742134, 'gb', 'Ashton Keynes', 1, 'ashton-keynes'),
(36254, 742134, 'gb', 'Avebury', 1, 'avebury'),
(36255, 742134, 'gb', 'Box', 1, 'box'),
(36256, 742134, 'gb', 'Bradford On Avon', 1, 'bradford-on-avon'),
(36257, 742134, 'gb', 'Bulford', 1, 'bulford'),
(36258, 742134, 'gb', 'Calne', 1, 'calne'),
(36259, 742134, 'gb', 'Castle Combe', 1, 'castle-combe'),
(36260, 742134, 'gb', 'Castle Eaton', 1, 'castle-eaton'),
(36261, 742134, 'gb', 'Chippenham', 1, 'chippenham'),
(36262, 742134, 'gb', 'Cippenham', 1, 'cippenham'),
(36263, 742134, 'gb', 'Colerne', 1, 'colerne'),
(36264, 742134, 'gb', 'Compton', 1, 'compton'),
(36265, 742134, 'gb', 'Corsham', 1, 'corsham'),
(36266, 742134, 'gb', 'Cricklade', 1, 'cricklade'),
(36267, 742134, 'gb', 'Devizes', 1, 'devizes'),
(36268, 742134, 'gb', 'Goring', 1, 'goring'),
(36269, 742134, 'gb', 'Highworth', 1, 'highworth'),
(36270, 742134, 'gb', 'Hindon', 1, 'hindon'),
(36271, 742134, 'gb', 'Kilmington', 1, 'kilmington'),
(36272, 742134, 'gb', 'Lacock', 1, 'lacock'),
(36273, 742134, 'gb', 'Longleat', 1, 'longleat'),
(36274, 742134, 'gb', 'Malmesbury', 1, 'malmesbury'),
(36275, 742134, 'gb', 'Marden', 1, 'marden'),
(36276, 742134, 'gb', 'Marlborough', 1, 'marlborough'),
(36277, 742134, 'gb', 'Melksham', 1, 'melksham'),
(36278, 742134, 'gb', 'Mere', 1, 'mere'),
(36279, 742134, 'gb', 'Pewsey', 1, 'pewsey'),
(36280, 742134, 'gb', 'Salisbury', 1, 'salisbury'),
(36281, 742134, 'gb', 'Slaughterford', 1, 'slaughterford'),
(36282, 742134, 'gb', 'South Marston', 1, 'south-marston'),
(36283, 742134, 'gb', 'Southwick', 1, 'southwick'),
(36284, 742134, 'gb', 'Stanton Fitzwarren', 1, 'stanton-fitzwarren'),
(36285, 742134, 'gb', 'Stourton', 1, 'stourton'),
(36286, 742134, 'gb', 'Swindon', 1, 'swindon'),
(36287, 742134, 'gb', 'Trowbridge', 1, 'trowbridge'),
(36288, 742134, 'gb', 'Warminster', 1, 'warminster'),
(36289, 742134, 'gb', 'Westbury', 1, 'westbury'),
(36290, 742134, 'gb', 'West Kington', 1, 'west-kington'),
(36291, 742134, 'gb', 'Wilton', 1, 'wilton'),
(36292, 742134, 'gb', 'Wootton Bassett', 1, 'wootton-bassett'),
(36293, 742134, 'gb', 'Wootton Rivers', 1, 'wootton-rivers'),
(36294, 742134, 'gb', 'Wroughton', 1, 'wroughton');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(742179, 'gb', 'Worcestershire', 1, 'worcestershire');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(36295, 742179, 'gb', 'Abberley', 1, 'abberley'),
(36296, 742179, 'gb', 'Badsey', 1, 'badsey'),
(36297, 742179, 'gb', 'Bentley', 1, 'bentley'),
(36298, 742179, 'gb', 'Bewdley', 1, 'bewdley'),
(36299, 742179, 'gb', 'Broadway', 1, 'broadway'),
(36300, 742179, 'gb', 'Bromsgrove', 1, 'bromsgrove'),
(36301, 742179, 'gb', 'Droitwich', 1, 'droitwich'),
(36302, 742179, 'gb', 'Eckington', 1, 'eckington'),
(36303, 742179, 'gb', 'Evesham', 1, 'evesham'),
(36304, 742179, 'gb', 'Frith Common', 1, 'frith-common'),
(36305, 742179, 'gb', 'Hartlebury', 1, 'hartlebury'),
(36306, 742179, 'gb', 'Kemerton', 1, 'kemerton'),
(36307, 742179, 'gb', 'Kidderminster', 1, 'kidderminster'),
(36308, 742179, 'gb', 'Kington', 1, 'kington'),
(36309, 742179, 'gb', 'Little Witley', 1, 'little-witley'),
(36310, 742179, 'gb', 'Malvern', 1, 'malvern'),
(36311, 742179, 'gb', 'Naunton', 1, 'naunton'),
(36312, 742179, 'gb', 'Pershore', 1, 'pershore'),
(36313, 742179, 'gb', 'Redditch', 1, 'redditch'),
(36314, 742179, 'gb', 'Rock', 1, 'rock'),
(36315, 742179, 'gb', 'Stone', 1, 'stone'),
(36316, 742179, 'gb', 'Stourport On Severn', 1, 'stourport-on-severn'),
(36317, 742179, 'gb', 'Tenbury Wells', 1, 'tenbury-wells'),
(36318, 742179, 'gb', 'Upton Upon Severn', 1, 'upton-upon-severn'),
(36319, 742179, 'gb', 'Worcester', 1, 'worcester');

